MySQL密码正确却无法本地登录-1045

MySQL密码正确却无法本地登录-1045 Access denied for user 'root'@'localhost' (using password:YES

MySQL密码正确却无法本地登录

报错如下：

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

解决方法：

1、在启动mysql的参数中加入跳过密码问题方式，如下：

vim /etc/my.cnf

并在[mysql]下面加上skip-grant-tables，

这个用于跳过密码问题，但是这并不能彻底解决。

2、重启mysql服务

本人用的是Linux系统的Mysql，语句如下：

查看端口号：

ps aux|grep mysqld

查看状态：

systemctl status mysqld

重启mysql服务

systemctl restart mysqld

尝试连接：

mysql -uroot -p123456

输入密码，刚才已经设置跳过密码了可忽略

操作步骤如下：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

[root@localhost ~]# mysql -uroot -p123456 mysql> use mysql Database changed mysql> select user ,host, password from user where user = 'root' ; + ------+-----------------------+-------------------------------------------+ | user | host | password | + ------+-----------------------+-------------------------------------------+ | root | % | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | | root | localhost.localdomain | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | | root | 127.0.0.1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | | root | ::1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | + ------+-----------------------+-------------------------------------------+ 4 rows in set (0.02 sec)   mysql> update user set host= 'localhost' where user = 'root' and host= '%' ; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0   mysql> flush privileges ; Query OK, 0 rows affected (0.03 sec)   mysql> quit Bye

OK，退出mysql，重启mysql就解决问题了

前后对比一下：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

[root@localhost ~]# mysql -uroot -p mysql> use mysql; Database changed mysql> select user ,host, password from user where user = 'root' ; + ------+-----------------------+-------------------------------------------+ | user | host | password | + ------+-----------------------+-------------------------------------------+ | root | localhost | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | | root | localhost.localdomain | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | | root | 127.0.0.1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | | root | ::1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 | + ------+-----------------------+-------------------------------------------+ 4 rows in set (0.00 sec)   mysql> OK!

总结

以上所述是小编给大家介绍的MySQL密码正确却无法本地登录-1045 Access denied for user ''root''@''localhost'' (using password:YES，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
如果你觉得本文对你有帮助，欢迎转载，烦请注明出处，谢谢！

原文链接：https://www.cnblogs.com/hxun/archive/2019/12/20/12072850.html