MySQL Enterprise Firewall As of MySQL 8.0.26, this procedure is deprecated and subject to removal in a future MySQL version. See Migrating Account Profiles to Group Profiles. These stored procedures perform miscellaneous firewall management operations. Arguments: This routine requires the  FIREWALL_ADMIN  privilege. Example: This procedure was added in MySQL 8.0.26. MySQL Enterprise Firewall administrative functions provide an API for lower-level tasks such as synchronizing the firewall cache with the underlying system tables. Under normal operation, these functions are invoked by the firewall stored procedures, not directly by users.  For that reason, these function descriptions do not include details such as information about their arguments and return types. These functions perform management operations on firewall group profiles: This function removes an account from a group profile. It requires the  FIREWALL_ADMIN  privilege. Example: 1570 Firewall Group Profile Functions MySQL Enterprise Firewall Administrative Functions Firewall Miscellaneous Stored Procedures As of MySQL 8.0.26, account profiles are deprecated because group profiles can do anything account profiles can do. The  sp_migrate_firewall_user_to_group()  stored procedure converts a firewall account profile to a group profile with the acount as its single enlisted member. The conversion procedure is discussed in Migrating Account Profiles to Group Profiles. • sp_migrate_firewall_user_to_group( user ,  group ) • user : The name of the account profile to convert to a group profile, as a string in user_name @ host_name  format. The account profile must exist, and must not currently be in RECORDING  mode. • group : The name of the new group profile, which must not already exist. The new group profile has the named account as its single enlisted member, and that member is set as the group training account. The group profile operational mode is taken from the account profile operational mode. •Firewall Group Profile Functions •Firewall Account Profile Functions •Firewall Miscellaneous Functions • firewall_group_delist( group ,  user ) CALL sp_migrate_firewall_user_to_group(’fwuser@localhost’, ’mygroup); +----------------------------------------------------------------------+ | ERROR: PROTECTING mode requested for a@b but the allowlist is empty. | +----------------------------------------------------------------------+