Mysql安装报错之错误提示:1251-Client does not support authentication ...

225 阅读1分钟

解决办法:

1.直接修改 用管理员身份打开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可以连接成功,问题解决!