MySQL错误::“用户'root'@'localhost'的访问被拒绝 [英] MySQL Error: : 'Access denied for user 'root'@'localhost'

问题描述

$ ./mysqladmin -u root -p '已编辑'
输入密码:

$ ./mysqladmin -u root -p 'redacted'
Enter password:

mysqladmin:连接到"localhost"服务器失败的错误:
拒绝用户'root'@'localhost'的访问(使用密码:是)'

mysqladmin: connect to server at 'localhost' failed error:
'Access denied for user 'root'@'localhost' (using password: YES)'

我该如何解决?

推荐答案

1. 打开&根据您的发行版，编辑/etc/my.cnf或/etc/mysql/my.cnf.
2. 在[mysqld]下添加skip-grant-tables
3. 重新启动Mysql
4. 您现在应该可以使用以下命令mysql -u root -p
登录到mysql
5. 运行mysql> flush privileges;
6. 通过 ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
设置新密码
7. 返回/etc/my.cnf并删除/评论跳过授权表
8. 重新启动Mysql
9. 现在您将可以使用新密码mysql -u root -p
登录

1. Open & Edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distro.
2. Add skip-grant-tables under [mysqld]
3. Restart Mysql
4. You should be able to login to mysql now using the below command mysql -u root -p
5. Run mysql> flush privileges;
6. Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
7. Go back to /etc/my.cnf and remove/comment skip-grant-tables
8. Restart Mysql
9. Now you will be able to login with the new password mysql -u root -p

这篇关于MySQL错误::“用户'root'@'localhost'的访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！