我正在尝试设置用户 root 的密码,但出现以下错误,知道吗?
+----------------------------------------------------------------------------------------------------------------------------------------+
| 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
替换为您的实际密码。
关于mysql - '用户 'root' @'localhost' 的访问被拒绝(使用密码 : NO)',我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/8537531/