Navicat连接Mysql报错:Client does not support authentication protocol requested by server;

在安装好MySQL之后,我使用Navicat去连接数据库的时候,报错,根据网络上的一些教程,解决了问题

Navicat连接Mysql报错:Client does not support authentication protocol requested by server;

先连接到数据库

Navicat连接Mysql报错:Client does not support authentication protocol requested by server;

命令如下:

1、use mysql;

2、alter user 'root'@'localhost' identified with mysql_native_password by '********';//这里是你的密码,我的截图没有截全

3、flush privileges;

之后就连接成功了

Navicat连接Mysql报错:Client does not support authentication protocol requested by server;