MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The firewall_groups table
provides a view into the in-memory data cache for MySQL Enterprise Firewall. It
lists names and operational modes of registered firewall group
profiles. It is used in conjunction with the
mysql.firewall_groups system table that
provides persistent storage of firewall data; see
MySQL Enterprise Firewall Tables.
The firewall_groups table has
these columns:
NAME
The group profile name.
MODE
The current operational mode for the profile. Permitted
mode values are OFF,
DETECTING,
PROTECTING, and
RECORDING. For details about their
meanings, see Firewall Concepts.
USERHOST
The training account for the group profile, to be used
when the profile is in RECORDING mode.
The value is NULL, or a
non-NULL account that has the format
user_name@host_name
If the value is NULL, the firewall
records allowlist rules for statements received from
any account that is a member of the group.
If the value is non-NULL, the
firewall records allowlist rules only for statements
received from the named account (which should be a
member of the group).
The firewall_groups table has no
indexes.
TRUNCATE TABLE is not permitted
for the firewall_groups table.
The firewall_groups table was
added in MySQL 8.0.23.