1 of 1

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 .

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 ), 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}