Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA MySQL Enterprise Firewall Tables  /  The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table

28.7.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table

TheMYSQL_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 themysql.firewall_users system table that provides persistent storage of firewall data; seeMySQL Enterprise Firewall Tables.

TheMYSQL_FIREWALL_USERS table has these columns:

  • USERHOST

    The account profile name. Each account name has the formatuser_name@host_name.

  • MODE

    The current operational mode for the profile. Permitted mode values areOFF,DETECTING,PROTECTING,RECORDING, andRESET. For details about their meanings, seeFirewall Concepts.

As of MySQL 8.0.26, this table is deprecated and subject to removal in a future MySQL version. SeeMigrating Account Profiles to Group Profiles.