MySQL Enterprise Firewall DROP FUNCTION IF EXISTS firewall_group_delist; DROP FUNCTION IF EXISTS firewall_group_enlist; DROP FUNCTION IF EXISTS mysql_firewall_flush_status; DROP FUNCTION IF EXISTS normalize_statement; DROP FUNCTION IF EXISTS read_firewall_group_allowlist; DROP FUNCTION IF EXISTS read_firewall_groups; DROP FUNCTION IF EXISTS read_firewall_users; DROP FUNCTION IF EXISTS read_firewall_whitelist; DROP FUNCTION IF EXISTS set_firewall_group_mode; DROP FUNCTION IF EXISTS set_firewall_mode; DROP PROCEDURE IF EXISTS mysql.sp_firewall_group_delist; DROP PROCEDURE IF EXISTS mysql.sp_firewall_group_enlist; DROP PROCEDURE IF EXISTS mysql.sp_reload_firewall_group_rules; DROP PROCEDURE IF EXISTS mysql.sp_reload_firewall_rules; DROP PROCEDURE IF EXISTS mysql.sp_set_firewall_group_mode; DROP PROCEDURE IF EXISTS mysql.sp_set_firewall_group_mode_and_user; DROP PROCEDURE IF EXISTS mysql.sp_set_firewall_mode; 6.4.7.3 Using MySQL Enterprise Firewall Enabling or Disabling the Firewall To enable or disable the firewall, set the  mysql_firewall_mode  system variable. By default, this variable is enabled when the firewall is installed. To control the initial firewall state explicitly, you can set the variable at server startup. For example, to enable the firewall in an option file, use these lines: After modifying  my.cnf , restart the server to cause the new setting to take effect. Alternatively, to set and persist the firewall setting at runtime: SET PERSIST  sets the value for the running MySQL instance. It also saves the value, causing it to carry over to subsequent server restarts. To change a value for the running MySQL instance without having it Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall” . This section describes how to configure MySQL Enterprise Firewall using SQL statements. Alternatively, MySQL Workbench 6.3.4 or higher provides a graphical interface for firewall control. See MySQL Enterprise Firewall Interface. •Enabling or Disabling the Firewall •Assigning Firewall Privileges •Firewall Concepts •Registering Firewall Group Profiles •Registering Firewall Account Profiles •Monitoring the Firewall •Migrating Account Profiles to Group Profiles [mysqld] mysql_firewall_mode=ON SET PERSIST mysql_firewall_mode = OFF; SET PERSIST mysql_firewall_mode = ON; 1550