出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方法。
背景介绍Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
得物技术浅谈MySQL 8.0:新的身份验证插件(caching_sha2_password) - SegmentFault 思否
出现这个问题是因为mysql8之前的加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password,所以解决问题方法可以是:把mysql用户登录密码加密规则还原成mysql_native_password。
本人用的客户端是:Sequel Ace(开源免费,轻量,Sequel Pro问题过多)
步骤1、控制台登录MySQL用户,本人直接用的root账户;
MacBook-Pro:bin home$ mysql -uroot -p Enter password:
2、还原加密规则;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD' PASSWORD EXPIRE NEVER; Query OK, 0 rows affected (0.20 sec) mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD'; Query OK, 0 rows affected (0.01 sec)



