今天安装Navicat连接mysql的时候竟然出问题了,报错为Client does not support authentication protocol requested by server
解决办法:在mysql的命令窗口输入如下命令
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;
实例如下:
注释:123456密码是自己设置的,可以自行更改