用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
- caching_sha 插件 password 身份 cachingcaching_sha插件password身份 authentication caching_sha password caching password runtimeerror cryptography caching_sha authentication caching_sha password navicat authentication caching_sha password错误 caching_sha password错误caching mysql authentication caching_sha password caching_sha password caching plugin authentication caching_sha navicate password caching_sha password caching navicat