Friday, February 28, 2014

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

Answer is,  :)

You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'.

refer : http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw

Then delete those anonymous users,

mysql> DELETE FROM mysql.user WHERE User='';
mysql> flush privileges;

Done..!