navicat 连接 mysql 连接出现Authentication plugin 'caching_sha2_password' cannot be loaded
1.进行mysql bin中打开cmd登录
mysql -uroot -proot1
2.修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root1' PASSWORD EXPIRE NEVER;
3.更新一下用户的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root1';
4. 刷新权限
FLUSH PRIVILEGES;