Category Archives : database


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

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. […]