原因：mysql登錄驗證的默認插件變更琢唾，從mysql_native_password變?yōu)閏aching_sha2_password寡壮。
1.輸入密碼進入數(shù)據(jù)庫
mysql -u root -p
SHOW DATABASES;
use mysql;
進入mysql數(shù)據(jù)庫
2生闲、修改加密規(guī)則：
ALTER USER 'root'@'localhost' IDENTIFIED BY '修改的密碼' PASSWORD EXPIRE NEVER;
3寡键、使用mysql_native_password認證插件：
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '修改的密碼';
4掀泳、刷新權(quán)限：
FLUSH PRIVILEGES;
5、重置密碼：
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密碼'
6西轩、刷新權(quán)限
FLUSH PRIVILEGES;
7员舵、查看身份驗證插件
SELECT Host, User, plugin from user;
過程
