Navicat初次连接MySQL报错解决办法
Navicat初次连接MySQL报错解决办法
1.用管理员模式打开cmd
2.执行mysql -u root -p进入mysql
3.在mysql>提示后执行以下命令
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
#更新一下用户的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
#刷新权限
FLUSH PRIVILEGES;
# 重置密码(这里重置123456,根据自己习惯设置,尽量不要太复杂以免自己忘记)
alter user 'root'@'localhost' identified by '123456';
# 退出MySQL
/q