navicat 连接 mysql 出现Client does not support authentication protocol requested by server

方法一：

mysql> SET PASSWORD FOR  ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);

其二:

mysql> UPDATE mysql.user SET Password =OLD_PASSWORD(‘newpwd’)  WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;

上面some_user、some_host、newpwd按自己实际情况修改。

方法二：

USE mysql; 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123123'; 
FLUSH PRIVILEGES;

root是用户名，localhost是ip地址127.0.0.1都是特指本机，mysql_native_password是旧的密码验证机制，123123是新密码，最后别忘了分号；