升级到mysql8以后，原有的Mysql Workbench连接出现下面的异常

1
Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

原因

mysql客户端不支持caching_sha2_password; mysql8新建用户默认采用这种加密方式

1
mysqladmin -uroot password 'mypassword'

解决方法

修改服务端用户密码加密方式为mysql_native_password

1
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypassword';