解决MySQL 8.0 SQLYog工具连接报错1251

报错提示，如图： “错误号码1251 Client does not support authentication protocol requested by server; consider upgrading MySQL client”

1 修改加密方式

[root@oracle ~]# mysql -uroot -p123 mysql> alter user jackson@'%' identified by '123' password expire never;

2 修改密码

mysql> alter user jackson@'%' identified with mysql_native_password by 'jackson'; Query OK, 0 rows affected (0.00 sec)

3 刷新权限

mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)

查看

mysql> select user,host,authentication_string from mysql.user; +------------------+-----------+------------------------------------------------------------------------+ | user | host | authentication_string | +------------------+-----------+------------------------------------------------------------------------+ | jackson | % | *2B65D680FC14F81C0FA1A93851483B57C1753DF8 | | wzx | % | $A$005$V\j5.Lc_;;{l 16iVJYza4IM1aeaJuJZlz1dIa0vcIf/Tefsm3uhHYiB7 | | mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | mysql.session | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | mysql.sys | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | root | localhost | $A$005$aLNA`S}geaGbnI.0.i1fkT0C0n3QycExMWvtpi7j44kgqBiyV8G2I0r9 | +------------------+-----------+------------------------------------------------------------------------+ 6 rows in set (0.00 sec)

4 重新测试连接

注意防火墙需要开放3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent firewall-cmd --reload

MySQL8.0授权新用户远程连接方式

需要先创建用户并设置密码 mysql> create user jackson@'%' identified by '123'; 修改加密方式 mysql> alter user jackson@'%' identified with mysql_native_password by 'jackson'; 授权远程连接 mysql> grant all privileges on *.* to jackson@'%' with grant option;