'拒绝用户'root'@'localhost'的访问(使用密码:否)' [英] 'Access denied for user 'root'@'localhost' (using password: NO)'

问题描述

我正在尝试设置用户root的密码，但是我收到以下错误，知道吗?

I'm trying to set the password of the user root but I'm gettin the error below, any idea?

+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*436576511F70A4E3B305E1AB8E209851945D8687' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)


mysql> exit
Bye
root@tirengarfio:/var/www/rs2# mysqladmin -u root password foo,
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

推荐答案

$ mysqladmin -u root -p password
Enter password: 
New password: 
Confirm new password:

password将按字面意义输入.这是一个命令.您不必用实际的密码替换password.

password is to be typed literally. It's a command. You don't have to substitute password with your actual password.

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