MySQL- Authentication plugin 'caching_sha2_password' cannot be loaded-

MySQL连接Navicat premium时报错:
Authentication plugin 'caching_sha2_password' cannot be loaded:

解决办法:
打开terminal或者命令行

1
2

 mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';

root为设置的用户名,可以自己更改
如果是远程连接, 需要把localhost换为对应IP
密码根据自己的情况填写.

参考:
https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
解决办法:
ALTER USER ‘username‘@’ip_address’ IDENTIFIED WITH mysql_native_password BY ‘password’;

• ← Previous Post
• Next Post →