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

  上篇刚写了安装Mysql,想用Navicat去连接,然后就报错了,此处记录报错解决。

  Navicat连接MySQL Server8.0版本时出现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;

posted @ 2018-06-20 12:03  zzz紫川  阅读(66319)  评论(8编辑  收藏