技术饭

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

copylian    0 评论    776 浏览    2019.08.24

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

Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested  by server;解决如下:

985807-20180620115937639-775074688.png

985807-20180620120002560-516347143.png

命令如下:

1、use mysql;

2、alter user 'root'@'localhost' identified with mysql_native_password by '********';

3、flush privileges;

CopyLian
感谢你的支持,我会继续努力!
扫码打赏,感谢您的支持!
Navicat Mysql 报错 

文明上网理性发言!

  • 还没有评论,沙发等你来抢