password_expired feature which allows to set a user’s password as expired.
This has been added to the mysql.user table and its default value it’s “N.” You can change it to “Y” using the
ALTER USER statement.
Here’s an quick example on how to set expiration date for a MySQL user account:
mysql> ALTER USER ‘testuser’@’localhost’ PASSWORD EXPIRE;
mysql> ALTER […]Read more