Navicat连接Mysql报错:Client does not support authentication protocol requested by server;
Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server;解决如下:
新装的mysql用Navicat连接,提示Client does not support authentication protocol requested by server;记录一下怎么解决的
1,先用mysql -uroot -p登陆mysql
2,use mysql;
3,alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘你自己的mysql密码’;
4,flush privileges;
连接成功