MySQL Password Expiration

Password expiration problem is a problem that could raise in mySql database. If you are running a drupal website which is connected to mysql database, you could face this error. Referring  to mysql reference manual document, the password expiration is 360 days.

You can change this using the following mysql command:

ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE INTERVAL 90 DAY;

or you can disable password expiration

ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE NEVER;

Back to our problem, you need to open the mysql command utility and change the old password to a new one as shown in the figure below:

Now, you can run your application, or your database as usual.