MySQL 9.6 Reference Manual Including MySQL NDB Cluster 9.6
The temporary_account_locks table
lists the users with temporarily locked accounts.
The temporary_account_locks table
has these columns:
USER
The user name of the account used.
HOST
The host name of the account used.
LOCKED
Whether the account is currently temporarily locked. The
value is YES or NO.
FAILED_LOGIN_ATTEMPTS
The number of login attempts, as defined in the password locking policy.
REMAINING_LOGIN_ATTEMPTS
The number of login attempts remaining before the account is locked.
PASSWORD_LOCK_TIME
Lock time, in days, as defined in the password locking policy.
LOCKED_SINCE
The date the account was locked. NULL
if the account is not locked.
LOCKED_UNTIL
The date the account is locked until.
NULL if the account is not locked.