mysql Access denied for user ''@'localhost' to database

安裝Mysql後在終端輸入mysql, mysql

成功啟動,退出,再輸入mysqladmin -u root password XXXXX, 出現錯誤:mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

 

如先輸入mysql,成功啟動後輸入use mysql,出現如下錯誤:Access denied for user ''@'localhost' to database 'mysql'

 

還有,輸mysql可以,輸mysql -u root就出錯瞭:

Access denied for user 'root'@'localhost' (using password: NO).

 

The reason is:

是昨日更新ROOT密碼時出錯

update user set password = '123456' where user ="root" //這樣寫是錯的,密碼其實不是123456

應該為update user set password = password ('123456') where user = "root"

 

具體操作步驟:

關閉mysql:

# service mysqld stop

然後:

# mysqld_safe –skip-grant-tables(該命令完成後,可能終端不會提示輸入下一命令,下面命令在新開的終端中實現)

啟動mysql:

# service mysqld start

mysql -u root

mysql> use mysql

mysql> UPDATE user SET Password=PASSWORD('xxx') WHERE user='root';

mysql> flush privileges;

mysql>\q

You May Also Like