navicat-mysql账户登陆1064

Question

• 已经检查过登陆密码帐号没有问题

Answer 1

修改加密方式：ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
然后修改密码ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';