Navicat连接MySQL提示密码过期

mysql 5.7增加了两个字段password_last_changed、password_lifetime来完善安全策略。

可以设置参数default_password_lifetime来延长使用期限

或者

ALTER USER 'root'@localhost' PASSWORD EXPIRE INTERVAL 90 DAYS;
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' PASSWORD EXPIRE DEFAULT;

MySQL命令行提示错误[You must reset your password using ALTER USER statement before executing this statement.]，请参见：http://blog.csdn.net/fay462298322/article/details/52788611