Friday, July 30, 2010

MySQL error: ERROR 1045 (28000)

PROBLEM
Trying to login MySQL with a newly created user, error:

mysql -u username-p
Enter password: xxxxx
ERROR 1045 (28000): Access denied for user 'xxxxx'@'localhost' (using password: YES)


SOLUTION
Restart MySQL
( sudo /etc/init.d/mysql restart )