navicat连接mysql报错（navicat连接mysql报错doesnot）

navicat连接mysql报错（navicat连接mysql报错doesnot）##停止MySQL服务sudo /usr/local/mysql/support-files/mysql.server stop##启动MySQL服务sudo /usr/local/MySQL/support-files/mysql.server startALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的root账号密码';有时候可能需要重启或者刷新一下flush privileges;

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