[error] [mysql] 1251 - Client does not support authentication protocol requested by server
客户端使用navicat for mysql。本地安装了mysql 8.0。但是在链接的时候提示:
1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
主要原因是mysql服务器要求的认证插件版本与客户端不一致造成的。
打开mysql命令行输入如下命令查看,系统用户对应的认证插件:
select user, plugin from mysql.user;
可以看到root用户使用的plugin是caching_sha2_password,mysql官方网站有如下说明:
Important
The caching_sha2_password authentication plugin on the server requires new versions of connectors and clients, which add support for the new MySQL 8.0 default authentication.