mac 2059 - Authentication plugin 'caching_sha2_password' cannot be loaded:

今天在用navicat连接mysql 8.0的时候出现了下面的错误：

2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(../Frameworks/caching_sha2_password.so, 2): image not found

 

 

解决方法

终端登陆mysql，然后操作步骤如下：

cd /usr/local/mysql
cd bin
 ./mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ' 你的密码';

参考文献

[1]. Mac 使用 Navicat连接 localhost 报错：2059 - Authentication plugin 'caching_sha2_password' cannot be loaded. https://blog.youkuaiyun.com/Enjolras_fuu/article/details/87687834