1251 - Client does not support authentication protocol requested by server consider upgrading MySQl

在服务器上MYSQL8版本创建新用户

CREATE USER 'test1'@'%' IDENTIFIED BY 'test1';
GRANT ALL PRIVILEGES ON *.* TO 'test1'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

在本地Navicat Premium连接时报错显示下面的

1251 - Client does not support authentication protocol requested by server consider upgrading MySQl

在本地通过cmd命令连接mysql -utest1 -ptest1没有问题，能够正常连接。

由此，可以判断是Navicat Premium客户端的问题导致的。

有2种解决方案：

1 升级Navicat客户端

2 修改加密方式

ALTER USER 'test1'@'%' IDENTIFIED WITH mysql_native_password BY 'test1';
FLUSH PRIVILEGES;