Navicat for MySQL远程连接mysql时报错1251

报错信息:

1251 - Client does not support authentication protocol requested by server;

  解决方案:

1.更改加密方式:

mysql> ALTER USER 'root' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

2.更改密码:

mysql> ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY '123123';
Query OK, 0 rows affected (0.00 sec)

3.刷新

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

参考:

http://www.cnblogs.com/shiysin/p/shiysin.html

原文地址:https://www.cnblogs.com/shannen/p/12519491.html