MySQL新身份验证插件caching_sha2_password

 

用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