mysql登入報錯“Access denied for user 'root'@'localhost' (using password: YES”的處理方法

標籤：ar   os   使用   sp   for   檔案   bs   ad   as   

使用/etc/mysql/debian.cnf檔案中[client]節提供的使用者名稱和密碼: 

檔案內容:

[client]
host = localhost
user = debian-sys-maint   //使用者名稱
password = Xgsuj2n8rlvw7jUO  //密碼
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = Xgsuj2n8rlvw7jUO
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

在命令列輸入:

# mysql -udebian-sys-maint -p 

Enter password: <輸入[client]節的密碼> 

#use mysql

mysql>update user set password=password("123456") where user="root";

mysql>flush privileges;

mysql> quit 

# mysql -uroot -p 

Enter password: <輸入新設的密碼newpassword> 

mysql> 

到此成功

mysql登入報錯“Access denied for user 'root'@'localhost' (using password: YES”的處理方法