ALTER USER Statement
ALTER USER user_specification [, user_specification] ...
user_specification:
user PASSWORD EXPIRE
For each account, ALTER USER expires its password. For example:
ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE;
Password expiration for an account affects the corresponding row of the mysql.user system table: The server sets the password_expired column to 'Y'.