MySQL Enterprise Firewall mysql>  SELECT USERHOST FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS; +-------------------------------+ | USERHOST | +-------------------------------+ | admin@localhost | | local_client@localhost | | remote_client@abc.example.com | +-------------------------------+ 2. For each account profile identified by the previous step, convert it to a group profile: CALL mysql.sp_migrate_firewall_user_to_group(’admin@localhost’, ’admins’); CALL mysql.sp_migrate_firewall_user_to_group(’local_client@localhost’, ’local_clients’); CALL mysql.sp_migrate_firewall_user_to_group(’remote_client@localhost’, ’remote_clients’); In each case, the account profile must exist and must not currently be in  RECORDING  mode, and the group profile must not already exist. The resulting group profile has the named account as its single enlisted member, which is also set as the group training account. The group profile operational mode is taken from the account profile operational mode. For additional details about  sp_migrate_firewall_user_to_group() , see Firewall Miscellaneous Stored Procedures. The following sections provide a reference to MySQL Enterprise Firewall elements: 6.4.7.4 MySQL Enterprise Firewall Reference •MySQL Enterprise Firewall Tables •MySQL Enterprise Firewall Administrative Functions •MySQL Enterprise Firewall Stored Procedures •MySQL Enterprise Firewall System Variables •MySQL Enterprise Firewall Status Variables MySQL Enterprise Firewall Tables MySQL Enterprise Firewall maintains profile information on a per-group and per-account basis. It uses tables in the  mysql  system database for persistent storage and  INFORMATION_SCHEMA  or Performance Schema tables to provide views into in-memory cached data. When enabled, the firewall bases operational decisions on the cached data. •Firewall Group Profile Tables •Firewall Account Profile Tables Firewall Group Profile Tables As of MySQL 8.0.23, MySQL Enterprise Firewall maintains group profile information using tables in the mysql  system database for persistent storage and Performance Schema tables to provide views into in- memory cached data. Each system and Performance Schema table is accessible only by accounts that have the  SELECT privilege for it. The  mysql.firewall_groups  table lists names and operational modes of registered firewall group profiles. The table has the following columns (with the corresponding Performance Schema firewall_groups  table having similar but not necessarily identical columns): 1564