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:
| Column | Description |
|---|---|
USER | In the format user_name@host_name. |
PASSWORD_ERRORS | If password_errors is ignored for the user, will be NULL. |
PASSWORD_EXPIRATION_TIME | A timestamp with the exact point in time calculated from password_last_changed and password_lifetime (i.e. days) stored for the user. |
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.
