mysql密码过期怎么解决

1、在命令行里面输入mysql -u root -p

2、输入密码，会输出错误信息ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. （不管）

3、输出命令重设密码SET PASSWORD = PASSWORD('xxxxxxxx');

4、然后你可以设置密码永不过期ALTER USER 'root'@争犸禀淫'localhost' PASSWORD EXPIRE NEVER;或者在配置文围泠惶底件里面[mysqld]default_password_lifetime=0