用Navicat连接mysql时,报错:Client does not support authentication protocol requested by server
解决办法:
在命令行登陆mysql,然后:
1、use mysql;
2、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
3、flush privileges;
大功告成:
用Navicat连接mysql时,报错:Client does not support authentication protocol requested by server
解决办法:
在命令行登陆mysql,然后:
1、use mysql;
2、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
3、flush privileges;
大功告成: