直接修改
用管理员身份打开 cmd, 输入 "mysql -u root -p [-h locahost -P 3306]"(中括号内是默认内容) 回车输入 root 用户密码进入 MySQL 客户端, 然后:
- MySQL> alter user [email protected]localhost identified by 'newpassword' password expire never;
- MySQL> alter user [email protected]localhost identified with mysql_native_password by 'newpassword';
- MySQL> flush privileges; # 刷新权限
其中,"newpassword" 是 root 用户新密码.
此时, Navicat 可以连接成功, 问题解决!
来源: http://www.bubuko.com/infodetail-3489204.html