ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' MySQL '

Install MySQL under CentOS, connect MySQL with the root account, and create a database that prompts for errors:

Tip: ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' MySQL '. On the internet to find a more popular method (see method one), done. Today again with this try, but do not make, in the Internet to find a half-day, finally found that because of the MySQL database user table, there is a username is empty account is anonymous account, resulting in the time of login is the root, but the actual is anonymous login, through the error prompt "@" LocalHost ' can be seen, so the solution to see method two.

method One:
1. Turn off MySQL
# Service Mysqld Stop
2. Blocking Permissions
# Mysqld_safe--skip-grant-table
Screen appears: Starting demo from .....
3. Start a new terminal input
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
Mysql> FLUSH privileges;//Remember to say this, otherwise if you close the previous terminal, the original error will appear
Mysql> \q

Method Two:
1. Turn off MySQL
# Service Mysqld Stop
2. Blocking Permissions
# Mysqld_safe--skip-grant-table
Screen appears: Starting demo from .....
3. Start a new terminal input
# mysql-u Root MySQL
mysql> Delete from user where user= ';
Mysql> FLUSH privileges;//Remember to say this, otherwise if you close the previous terminal, the original error will appear
Mysql> \q

Reference URL: http://blog.csdn.net/tys1986blueboy/article/details/7056835

Transferred from: http://www.cnblogs.com/Anker/p/3551610.html#3679998

ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' MySQL '