With MDEV-23729 users should be able to query which users a blocked due to max_password_errors. This feature request is to enhance this feature having a table like "blocked_accounts" in the information schema which stores all currently blocked (and maybe also locked) accounts and an information why they are blocked. Possible reasons are:

max-password-errors reached
max_connect_errors reached
MAX_CONNECTIONS_PER_HOUR reached (ER_USER_LIMIT_REACHED)
MAX_USER_CONNECTIONS (ER_TOO_MANY_USER_CONNECTIONS)
password expired
account locked
secure_auth set => mysql_old_password is used
The table content should only be accessible for a user with privilege CONNECTION ADMIN