1251 – Client does not support authentication protocol requested by server; consider upgrading Mysql client

1251 - Client does not support authentication protocol requested by server; consider upgrading MysOl client

解决方案：

1.3.1 数据库服务用户管理

修改已经创建用户加密插件信息

mysql> alter user 'baimeidashu'@'192.168.30.%' identified with mysql_native_password by '123456';

flush privileges;

mysql> select user,host,authentication_string,plugin from mysql.user;

修改前 ：

修改后：

再次测试，登录成功：

欢迎来撩 ： 汇总all