Sequel Pro 连接 mysql 8.3 失败 报错如下:
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 0x0002): tried: '/usr/local/lib/plugin/caching_sha2_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/lib/plugin/caching_sha2_password.so' (no such file), '/usr/local/lib/plugin/caching_sha2_password.so' (no such file)
解决方法:
可以将用户的认证插件更改为 mysql_native_password
,这是 MySQL 早期版本使用的插件,通常与大多数客户端兼容。
- 登录到 MySQL:
mysql -u root -p
- 查看用户认证插件:
sql复制代码
SELECT user, host, authentication_string, plugin FROM mysql.user;
- 更改用户认证插件:
ALTER USER 'yourusername'@'yourhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
FLUSH PRIVILEGES;
如果连接上后打开异常,
可使用test build版本, https://sequelpro.com/test-builds