Information Schema USERS Table

MariaDB starting with 11.5

The Information Schema USERS table contains information about users, password expiry, and the limits set by max_password_errors. Unprivileged users can access their own data, which is different to what mysql.global_priv provides.

It contains the following columns:

USERIn the format user_name@host_name.
PASSWORD_ERRORSIf password_errors is ignored for the user, will be NULL.
PASSWORD_EXPIRATION_TIMEA timestamp with the exact point in time calculated from password_last_changed and password_lifetime (i.e. days) stored for the user.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.