Navicat和MySQL安装了好几天了,今天要用,打开Navicat新建连接MySQL,输入密码出现如下提示:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
一直以为是自己密码错误,弄了一晚上现在终于弄好了
参考原回复见贴吧第17楼
附代码:
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';
FLUSH PRIVILEGES;
打开MySQL将代码黏贴进去,点击那个黄色闪电执行代码