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

Solution:

1、在mysql服务器上用命令行连接mysql

2、执行如下命令:

a、use mysql;

b、alter user 'root'@'localhost' identified with mysql_native_password by  '********';   // '********' 这里写密码

c、flush privileges;

原文地址:https://www.cnblogs.com/lishidefengchen/p/10514667.html