Navicat for MySQL连接 MySQL 8.0.18 出现1251- Client does not support authentication protocol requested by server的解决办法
安装了MySQL 8之后,使用Navicat for MySQL连接,报以下错误:
1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
这是由于MySQL8中plugin使用caching_sha2_password,而Navicat for MySQL不支持这一协议。
解决办法
使用下面的命令更新root用户的plugin为mysql_native_password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
再次用Navicat for MySQL连接,成功
全部评论:1条