youhui

用sequel pro 工具登錄，連接失敗~！“Authentication plugin 'caching_sha2_password' cannot be loaded”

失敗原因：

mysql8 之前的版本中加密規則是mysql_native_password,而在mysql8之后,加密規則是caching_sha2_password

解決辦法：

把mysql用戶登錄密碼加密規則還原成mysql_native_password

 ALTER USER 'root'@'%' IDENTIFIED BY 'xxxx' PASSWORD EXPIRE NEVER;

 ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxx';

 FLUSH PRIVILEGES;

https://blog.csdn.net/qq_36131788/article/details/108704354 

https://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA==&mid=2247498935&idx=1&sn=9920832d0a11ae91522e2ceb2a9de7ca&chksm=ea82b944ddf530521ab44bd140704338fc24f89e6f3a35a364645136c17a952831c44f1eca18&scene=27