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

Ø  在使用mysql表时，提示：ERROR 1044 (42000): Access denied for user ''@'localhost' todatabase 'mysql'！

因为在mysql数据库的user表里，存在用户名为空的账户即匿名账户，导致登录的时候是虽然用的是root，但实际是匿名登录的，通过错误提示里的''@'localhost'可以看出来，于是解决办法如下（推荐使用方法一）

Ø  在使用密码连接数据库时，忘记密码或密码丢失，进行强制修改（推荐使用方法二）

方法一：删除空用户数据

1.关闭mysql

   # service mysqld stop

2.屏蔽权限

   # mysqld_safe --skip-grant-table

   屏幕出现： Starting demo from .....

3.新开起一个终端输入

   # mysql -u root mysql

   mysql> delete from user where USER='';

   mysql> FLUSH PRIVILEGES;//记得要这句话，否则如果关闭先前的终端，又会出现原来的错误

   mysql> \q

 

方法二：修改空账户用户登陆为root

1.关闭mysql

   # service mysqld stop  //离线安装为：service mysql stop

2.屏蔽权限

   # mysqld_safe --skip-grant-table

   屏幕出现： Starting demo from .....

3.新开起一个终端输入

# mysql -uroot mysql

   mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root';

//新密码为newpassword，可改为自己记忆密码

   mysql> FLUSH PRIVILEGES;//记得要这句话，否则如果关闭先前的终端，又会出现原来的错误

   mysql> \q

退出mysql后，重新启动mysql。

如下所示：

[root@localhost sbin]# mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.19 MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root'; Query OK, 4 rows affected (0.00 sec) Rows matched: 4  Changed: 4  Warnings: 0 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye [root@localhost sbin]#