MySQL 5.6 introduced the ability to expire passwords. Many work
environments have rules where it is mandatory to change passwords
on a regular basis. It is easy to expire a single account with a
ALTER USER 'dave'@'localhost' PASSWWORD EXPIRE;
command.
The mysql.user table
The mysql.user table now has a PASSWORD_EXPIRED column. A user attempting to login with an expired account using a client that supports, they will be prompted to change their password.
An example of being forced into sandbox mode and changing the password. Note that user does not have SUPER or other admin level privs to change passwords.
SET PASSWORD does not check to see if you are reusing your old …
[Read more]