content_image/670817.jpg content_image/670818.jpg content_image/670819.jpg content_image/670820.jpg
•The MYSQL_FIREWALL  plugin, along with server-side plugins named MYSQL_FIREWALL_USERS  and MYSQL_FIREWALL_WHITELIST  implement Performance Schema and INFORMATION_SCHEMA  tables that provide views into the registered profiles. 

•Profiles are cached in memory for better performance. Tables in the mysql  system database provide backing storage of firewall data for persistence of profiles across server restarts. 

•Stored procedures perform tasks such as registering firewall profiles, establishing their operational mode, and managing transfer of firewall data between the cache and persistent storage. 

•Administrative functions provide an API for lower-level tasks such as synchronizing the cache with persistent storage. 

•System variables enable firewall configuration and status variables provide runtime operational information. 

•The FIREWALL_ADMIN  and FIREWALL_USER  privileges enable users to administer firewall rules for any user, and their own firewall rules, respectively. 

## 6.4.7.2 Installing or Uninstalling MySQL Enterprise Firewall 

MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 6.4.7.1, “Elements of MySQL Enterprise Firewall” . Installation can be performed using a graphical interface or manually: 

•On Windows, MySQL Installer includes an option to enable MySQL Enterprise Firewall for you. 

•MySQL Workbench 6.3.4 or higher can install MySQL Enterprise Firewall, enable or disable an installed firewall, or uninstall the firewall. 

•Manual MySQL Enterprise Firewall installation involves running a script located in the share  directory of your MySQL installation. 

<img src='content_image/670817.jpg'>

<img src='content_image/670818.jpg'>

<img src='content_image/670819.jpg'>

## Important 

Read this entire section before following its instructions. Parts of the procedure differ depending on your environment. 

<img src='content_image/670820.jpg'>

## Note 

If installed, MySQL Enterprise Firewall involves some minimal overhead even when disabled. To avoid this overhead, do not install the firewall unless you plan to use it. 

For usage instructions, see Section 6.4.7.3, “Using MySQL Enterprise Firewall” . For reference information, see Section 6.4.7.4, “MySQL Enterprise Firewall Reference” . 

## Installing MySQL Enterprise Firewall 

•Installing MySQL Enterprise Firewall 

•Uninstalling MySQL Enterprise Firewall 

If MySQL Enterprise Firewall is already installed from an older version of MySQL, uninstall it using the instructions given later in this section and then restart your server before installing the current version. In this case, it is also necessary to register your configuration again. 

On Windows, you can use MySQL Installer to install MySQL Enterprise Firewall, as shown in Figure 6.2, “MySQL Enterprise Firewall Installation on Windows” . Check the Enable MySQL Enterprise Firewall 

