MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The MYSQL_FIREWALL_USERS table
provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists
names and operational modes of registered firewall account
profiles. It is used in conjunction with the
mysql.firewall_users system table that provides
persistent storage of firewall data; see
MySQL Enterprise Firewall Tables.
The MYSQL_FIREWALL_USERS table has
these columns:
USERHOST
The account profile name. Each account name has the format
user_name@host_name
MODE
The current operational mode for the profile. Permitted mode
values are OFF,
DETECTING, PROTECTING,
RECORDING, and RESET.
For details about their meanings, see
Firewall Concepts.
As of MySQL 8.0.26, this table is deprecated and subject to removal in a future MySQL version. See Migrating Account Profiles to Group Profiles.