### MYSQL密码过期的修改方法(your password has expired) ###
![在这里插入图片描述][20191017154736968.png]
* 解决方法:
1. 确保mysql服务已启动
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhaTQ1NDY5MjU5MA_size_16_color_FFFFFF_t_70]
2. 找到mysql命令行的客户端
![在这里插入图片描述][20191017153355201.png]
3. 执行以下命令
step 1: SET PASSWORD = PASSWORD('your new password');
step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
step 3: flush privileges;
4. 结束
理论上已经可以了,如果还有问题,试一下重启mysql的服务
### mysql设置密码过期时间 ###
SET GLOBAL default_password_lifetime = 90;
ALTER USER 'root'@'localhost' PASSWORD EXPIRE INTERVAL 90 DAY;
[20191017154736968.png]: /images/1611047396820.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhaTQ1NDY5MjU5MA_size_16_color_FFFFFF_t_70]: /images/1611047366457.png
[20191017153355201.png]: /images/1611047333465.png