今天安装了navicat 和 mysql,结果最后在navicat中连接mysql时,出现了如下错误提示:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
1
网上找了如下方法:
其一:
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 ‘831015’;
FLUSH PRIVILEGES;
root是用户名,localhost是ip地址127.0.0.1都是特指本机,mysql_native_password是旧的密码验证机制,831015是密码,最后别忘了分号;
navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案
最新推荐文章于 2023-09-10 17:27:53 发布