Mysql create database then create user. New user can’t login

This entry was posted in database on March 3, 2014 by techstruggles.

---

When you try to login to mysql with a newly created user, you may get:

 

ERROR 1044 (42000): Access denied for user

Try to ensure the user’s been granted sufficient privileges for the database.

 

For example,

create databases db;

create user ‘blah’@’localhost’ with password ‘password’;

grant all privileges on db.* to ‘blah’@’%’;  <—–IMPORTANT.  Didn’t work with *.*

flush privileges;

 

---