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

20161115141330

1、现象:

[root@localhost ~]# mysql -u root -p

Enter password:

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

2、原因:数据库中存在空用户所致

3、解决方案:

1)停用mysql服务:# service mysqld stop

2)输入命令:# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

3)登入数据库:# mysql -u root mysql

4)mysql> use mysql;

5)mysql> select user,host,password from user; 结果如下:

+------+-----------------------+----------+

| user | host | password |

+------+-----------------------+----------+

| root | % | mima |

| root | localhost.localdomain | mima |

| root | 127.0.0.1 | mima |

| | localhost | |

| | localhost.localdomain | |

+------+-----------------------+----------+

6)将上面查询出来的空用户删除:mysql> delete from user where user='';

7)退出数据库:mysql> quit

8)启动mysql服务:# service mysqld start

9)重新用命令‘mysql -u root -p’登录,OK!

马洪飞

但尽人事,莫问前程...

相关推荐

发表评论

电子邮件地址不会被公开。 必填项已用*标注

微信扫一扫,分享到朋友圈

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
返回顶部

显示

忘记密码?

显示

显示

获取验证码

Close