mysql在升级了版本后从8开始修改了加密规则,导致连接出现错误:
Authentication plugin ‘caching_sha2_password‘ cannot be loaded
解决方案就是更新密码以及加密方式
1 进入mysql
mysql -u root -p
2 修改加密规则以及密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
3 刷新
FLUSH PRIVILEGES;
4 重置
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
参考blog:
https://blog.csdn.net/qq_35393472/article/details/123610081