Ctrl+K

ALTER USER Statement

Contents

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

References#

Contents