错误:使用Navicat Premium 12链接mysql的时候报Authentication plugin 'caching_sha2_password' cannot be loaded:xxxxx啥的错误
原因:mysql8之前的加密规则是mysql_native_password执行本地身份的一个插件,但是再mysql8之后加密规则就变了caching_sha2_password
解决方法:
1.直接把navicat跟mysql版本对应上,加密规则也就会改变
2.再cmd中更改一下加密规则:
(1.)管理员身份运行cmd
(2)输入mysql -u root -p登录mysql
(3)修改一下加密规则更新密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码 (password自己输入密码)
(4)刷新权限并重置密码
FLUSH PRIVILEGES; #刷新权限
(5)可以连接了
- Authentication caching_sha password 错误 cachingauthentication caching_sha password错误 authentication caching_sha password caching authentication caching_sha password navicat mysql authentication caching_sha password authentication caching_sha navicate password caching_sha password错误caching password runtimeerror cryptography caching_sha caching_sha插件password身份 caching_sha password caching plugin caching_sha password caching navicat