Problems with user access to db
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 Answered by Ian Gilfillan in this comment.
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.