安装navicat 和 mysql,结果最后在navicat中连接mysql时,出现了如下错误提示:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法:
USE mysql;
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
FLUSH PRIVILEGES;
root是用户名,localhost是ip地址127.0.0.1都是特指本机,mysql_native_password是旧的密码验证机制,123456是密码,最后别忘了分号;