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

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

新装的MySQL,想用navicat连接,结果发现连接失败,失败原因:Client does not support authentication protocol requested by server;经过查阅资料,找到解决方法如下:
Navicat连接Mysql报错:Client does not support authentication protocol requested by server;
蓝色区域为数据库连接密码。

具体代码如下:

  • use mysql
  • alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
  • flush privileges;

执行完成后就可以正常使用navicat了。