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

posted @ 2020-03-18 19:13  你有我备注吗  阅读(311)  评论(2编辑  收藏  举报