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 | A current accumulated value of consecutive password login failures. If password_errors is not applicable for the user (see max_password_errors), PASSWORD_ERRORS will be NULL. Only password login attempts with nonempty password are taken into account. |
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.
