命令行連接mysql時(shí)出現(xiàn)Authentication plugin 'caching_sha2_password' cannot be loaded: 找不到指定的模塊。
- 通過如下命令進(jìn)入數(shù)據(jù)庫
mysql -uroot -p
2.之后執(zhí)行如下命令
ALTER USER 'root'@'localhost' IDENTIFIED BY 'abc@123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abc@123';
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'abc@123';
FLUSH PRIVILEGES;
將abc@123換成自己的密碼
之后關(guān)閉命令行,再次連接mysql即可
