navicat for mysql连接不成功_navicat连接mysql报错 does not support authentication...

navicat连接mysql时会报下面这个错误

client does not support authentication protocol requested by server;consider upgrading mysql client

其实就是没有授权导致

启动mysql，然后输入下面的命令

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的root账号密码';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的root账号密码';

有时候可能需要重启或者刷新一下

flush privileges;

##启动MySQL服务
sudo /usr/local/MySQL/support-files/mysql.server start

##停止MySQL服务
sudo /usr/local/mysql/support-files/mysql.server stop

##重启MySQL服务
sudo /usr/local/mysql/support-files/mysql.server restart