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

问题描述

考虑:

./mysqladmin -u root -p** '_redacted_'  

输出(包括输入密码):

Output (including typing the password):

输入密码:

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

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

我该如何解决这个问题?

How can I fix this?

推荐答案

1. 打开并编辑 /etc/my.cnf 或 /etc/mysql/my.cnf，具体取决于您的发行版.
2. 在[mysqld]
下添加skip-grant-tables
3. 重启 MySQL
4. 您现在应该可以使用以下命令登录 MySQL 了 mysql -u root -p
5. 运行mysql>刷新权限；
6. 设置新密码 ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
7. 返回/etc/my.cnf 并 remove/commentskip-grant-tables
8. 重启 MySQL
9. 现在你可以使用新密码登录了mysql -u root -p

1. Open and edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distribution.
2. Add skip-grant-tables under [mysqld]
3. Restart MySQL
4. You should be able to log in 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屋！