Cannot log in with created user in mysql

Posted by Brian G on Server Fault See other posts from Server Fault or by Brian G
Published on 2009-09-11T17:05:41Z Indexed on 2010/03/15 19:10 UTC
Read the original article Hit count: 578

Filed under:

Using this command

GRANT ALL PRIVILEGES ON *.* to brian@'%' identified by 'password';

I try to login with:

 mysql -u brian -ppassword

The error is:

ERROR 1045 (28000): Access denied for user 'brian'@'localhost' (using password: YES)

I am doing this as root and I did try to flush privileges.

I tried this with countless users but it does not seem to work. I can create a user with no password and login works. Command line and from phpmyadmin

© Server Fault or respective owner

Related posts about mysql

Related posts about privileges