MySQL Password expires

1. Log in to MySQL root user with mysql command line

2, re-modify the root password SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');

MySQL 5.7 adds two fields password_last_changed, password_lifetime to refine the security policy.

3, you can set the parameter default_password_lifetime to extend the period of use, or

ALTER USER ' root ' @localhost ' PASSWORD EXPIRE INTERVAL;

Validity validation 90 days

ALTER USER ' root ' @ ' localhost ' PASSWORD EXPIRE never;

Do not validate validity period

ALTER USER ' root ' @ ' localhost ' PASSWORD EXPIRE DEFAULT;

Set to default value

MySQL Password expires