mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when try

作者：小舞很执着 | 2024-07-11 09:51:50

踩

mysqldump: got error: 1045: access denied for user 'root'@'localhost' (using

mysqldump: Got error: 1045: Access denied for user ‘root’@’localhost’ (using password: YES) when trying to connect

解决办法:

登录mysql客户端
mysql -hserverip -uroot -p  或者 mysql -u root
mysql> use mysql;
set password for 'root'@'localhost' =password(''); 
flush privileges;
显示当前的user：
mysql> SELECT USER();1
2
3
4
5
6
7

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小舞很执着/article/detail/809562