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)
参考: