MySQL Enterprise Firewall As of MySQL 8.0.26, these tables are deprecated and subject to removal in a future MySQL version. See Migrating Account Profiles to Group Profiles. The  mysql.firewall_users  table lists names and operational modes of registered firewall account profiles. The table has the following columns (with the corresponding INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS  table having similar but not necessarily identical columns): The account profile name. Each account name has the format  user_name @ host_name . 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. The  mysql.firewall_whitelist  table lists allowlist rules of registered firewall account profiles. The table has the following columns (with the corresponding INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST  table having similar but not necessarily identical columns): The account profile name. Each account name has the format  user_name @ host_name . A normalized statement indicating an acceptable statement pattern for the profile. A profile allowlist is the union of its rules. An integer column that is a primary key for the table. This column was added in MySQL 8.0.12. MySQL Enterprise Firewall stored procedures perform tasks such as registering profiles with the firewall, establishing their operational mode, and managing transfer of firewall data between the cache and persistent storage. These procedures invoke administrative functions that provide an API for lower-level tasks. Firewall stored procedures are created in the  mysql  system database. To invoke a firewall stored procedure, either do so while  mysql  is the default database, or qualify the procedure name with the database name. For example: These stored procedures perform management operations on firewall group profiles: 1566 Firewall Group Profile Stored Procedures MySQL Enterprise Firewall Stored Procedures • ID • RULE • USERHOST • MODE • USERHOST •Firewall Group Profile Stored Procedures •Firewall Account Profile Stored Procedures •Firewall Miscellaneous Stored Procedures • sp_firewall_group_delist( group ,  user ) CALL mysql.sp_set_firewall_group_mode( group ,  mode );