Problems with user access to db

You are viewing an old version of this question. View the current version here.

I have MariaDB 10.1 installed. I am trying to get some software installed but am running into problems. I have created a database and user for that database, but when I run the software it cannot connect to the database. The user I created was on the database sam I used the command MySQL -u sam -p'sam's password' sam's database I get access denied for user 'sam'@'localhost' I used the command "grant all privileges on newdb.* to sam@localhost;" I also did a "grant usage on *.* to sam@localhost identified by 'sams password'; Is there something I am doing wrong? Is there something I am missing? Your help is appreciated. Thank you, Mark

Answer

You can check the mysql.user and mysql.db tables and see that everything is correct. Try connecting from the command line first (to both no database and then to the specific database) before trying to connect through the application to be sure where the error lies.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.