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.
firewall_groups table has
The group profile name.
The current operational mode for the profile. Permitted mode values are
RECORDING. For details about their meanings, see Firewall Concepts.
The training account for the group profile, to be used when the profile is in
RECORDINGmode. The value is
NULL, or a non-
NULLaccount that has the format
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).
firewall_groups table has no
firewall_groups table was
added in MySQL 8.0.23.