用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
标签:sha2,插件,加密,身份验证,mysql,caching,password,native From: https://www.cnblogs.com/youhui/p/17296922.html