Information Schema USERS Table

The Information Schema USERS table lists user accounts, including whether they are global or local, and details about their password expiration.

This table is available from MariaDB 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.

_{This page is licensed: CC BY-SA / Gnu FDL}