由于升级mysql版本问题 如果mysql版本高的话navicat就会报错:Client does not support authentication protocol requested by server;
解决方案:
1 登陆mysql
2切换数据库 : use mysql;
3 重写密码:alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
4 flush privileges;