ERROR 1862 (HY000): Your password has expired. To log in you must change

MySQL 23333 342℃ 0评论

1,修改/etc/my.cnf,将下面语句加入到[mysqld]字段下跳过验证并重启。

skip-grant-tables

2,进入到mysql库,修改密码过期选项。

use mysql;

update user set password_expired=’N’ where user=’root’;

3,将跳过密码改回,并重启MySQL。

 

本文链接地址: ERROR 1862 (HY000): Your password has expired. To log in you must change

转载请注明:蛋疼实验室 » ERROR 1862 (HY000): Your password has expired. To log in you must change

喜欢 (0)
发表我的评论
取消评论

*

表情 签到

Hi,请填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址