【1】sudo vim /etc/mysql/debian.cnf

顯示

# Automatically generated for Debian scripts. DO NOT TOUCH!

[client]

host? ? = localhost

user? ? = debian-sys-maint

password = yXFCM3LmQ5wZlcKU

socket? = /var/run/mysqld/mysqld.sock

[mysql_upgrade]

host? ? = localhost

user? ? = debian-sys-maint

password = yXFCM3LmQ5wZlcKU

socket? = /var/run/mysqld/mysqld.sock

-------------------------------------------------------------------------------------------------------------------------------------------

【2】用debian-sys-maint進(jìn)入mysql

mysql -u debian-sys-maint -p

password = yXFCM3LmQ5wZlcKU

use mysql

select * from user

select host,user,password_expired,password_last_changed,password_lifetime,account_locked from user;

【3】過濾查看用戶信息，我的是因?yàn)閜lugin=auth_socket 問題

select host,user,plugin,authentication_string,password_last_changed,password_lifetime from user;

+-----------+------------------+-----------------------+-------------------------------------------+

| host? ? ? | user? ? ? ? ? ? | plugin? ? ? ? ? ? ? ? | authentication_string? ? ? ? ? ? ? ? ? ? |

+-----------+------------------+-----------------------+-------------------------------------------+

| localhost | root? ? ? ? ? ? | auth_socket? ? ? ? ? | *DF4DD04B3437D57619CDDFDD68DF49E2FDCDB2A3 |

| localhost | mysql.session? ? | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| localhost | mysql.sys? ? ? ? | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| localhost | debian-sys-maint | mysql_native_password | *E635E132EF9AD03B99F30035D1F6ECBBFAB0F089 |

| %? ? ? ? | root? ? ? ? ? ? | mysql_native_password | *DF4DD04B3437D57619CDDFDD68DF49E2FDCDB2A3 |

+-----------+------------------+-----------------------+-------------------------------------------+

【4】將首條root的plugin個(gè)in更新?

update user set plugin="mysql_native_password" where plugin="auth_socket";

mysql> select host,user,plugin,authentication_string from user;

+-----------+------------------+-----------------------+-------------------------------------------+

| host? ? ? | user? ? ? ? ? ? | plugin? ? ? ? ? ? ? ? | authentication_string? ? ? ? ? ? ? ? ? ? |

+-----------+------------------+-----------------------+-------------------------------------------+

| localhost | root? ? ? ? ? ? | mysql_native_password | *DF4DD04B3437D57619CDDFDD68DF49E2FDCDB2A3 |

| localhost | mysql.session? ? | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| localhost | mysql.sys? ? ? ? | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| localhost | debian-sys-maint | mysql_native_password | *E635E132EF9AD03B99F30035D1F6ECBBFAB0F089 |

| %? ? ? ? | root? ? ? ? ? ? | mysql_native_password | *DF4DD04B3437D57619CDDFDD68DF49E2FDCDB2A3 |

+-----------+------------------+-----------------------+-------------------------------------------+

5 rows in set (0.00 sec)

[5]退出，重啟，解決問題

exit

sudo service mysql restart