错误提示
1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决办法
用管理员身份打开cmd,输入"mysql -u root -p" 回车输入root用户密码进入MySQL客户端,然后:
mysql> alter user root@localhost identified by 'newpassword' password expire never;
mysql> alter user root@localhost identified with mysql_native_password by 'newpassword';
mysql> flush privileges; # 刷新权限
其中"newpassword"是root用户新密码。再用Navicat连接就可以了,问题解决!