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;
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.