MySQL Expired Passwords

On some MySQL server configurations you might get errors similar to the ones below:

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

It means that current MySQL config is set to block passwords that were set a long time ago.

You can run some SQL queries that can result in additional errors and queries needed, OR you can disable password expiration with this line in /etc/my.cnf

default_password_lifetime=0

Needs mysql restart.


Share with Google Plus