<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-mysql-firewall-whitelist-table">
      </a>
      28.7.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045075934224">
  </a>
  <p>
   The
   <a class="link" href="information-schema-mysql-firewall-whitelist-table.html" title="28.7.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table">
    <code class="literal">
     MYSQL_FIREWALL_WHITELIST
    </code>
   </a>
   table
      provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists
      allowlist rules of registered firewall account profiles. It is
      used in conjunction with the
   <code class="literal">
    mysql.firewall_whitelist
   </code>
   system table that
      provides persistent storage of firewall data; see
   <a class="xref" href="firewall-reference.html#firewall-tables" title="MySQL Enterprise Firewall Tables">
    MySQL Enterprise Firewall Tables
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="information-schema-mysql-firewall-whitelist-table.html" title="28.7.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table">
    <code class="literal">
     MYSQL_FIREWALL_WHITELIST
    </code>
   </a>
   table
      has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       USERHOST
      </code>
     </p>
     <p>
      The account profile name. Each account name has the format
      <code class="literal">
       <em class="replaceable">
        <code>
         user_name
        </code>
       </em>
       @
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       RULE
      </code>
     </p>
     <p>
      A normalized statement indicating an acceptable statement
          pattern for the profile. A profile allowlist is the union of
          its rules.
     </p>
    </li>
   </ul>
  </div>
  <p>
   This table is deprecated and subject to removal in a future MySQL
      version. See
   <a class="xref" href="firewall-usage.html#firewall-account-profile-migration" title="Migrating Account Profiles to Group Profiles">
    Migrating Account Profiles to Group Profiles
   </a>
   .
  </p>
 </div>
 <br/>
</div>
