盒子
盒子

Mysql password expired

今天登录网页,突然出现了这个问题

1
Your password has expired. To log in you must change it using a client that supports expired passwords.

起始解决方法很简单,只需要登录到服务器中的 Mysql,然后修改root 的密码就可以了

1
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password', 'root'@'localhost' PASSWORD EXPIRE NEVER;