<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="security-options">
      </a>
      8.1.4 Security-Related mysqld Options and Variables
     </h3>
    </div>
   </div>
  </div>
  <p>
   The following table shows
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   options and
      system variables that affect security. For descriptions of each of
      these, see
   <a class="xref" href="server-options.html" title="7.1.7 Server Command Options">
    Section 7.1.7, “Server Command Options”
   </a>
   , and
   <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
    Section 7.1.8, “Server System Variables”
   </a>
   .
  </p>
  <div class="table">
   <a name="idm46045252704464">
   </a>
   <p class="title">
    <b>
     Table 8.1 Security Option and Variable Summary
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Security-related command-line options and system variables.">
     <colgroup>
      <col style="width: 20%"/>
      <col style="width: 15%"/>
      <col style="width: 15%"/>
      <col style="width: 15%"/>
      <col style="width: 15%"/>
      <col style="width: 15%"/>
      <col style="width: 15%"/>
     </colgroup>
     <thead>
      <tr>
       <th scope="col">
        Name
       </th>
       <th scope="col">
        Cmd-Line
       </th>
       <th scope="col">
        Option File
       </th>
       <th scope="col">
        System Var
       </th>
       <th scope="col">
        Status Var
       </th>
       <th scope="col">
        Var Scope
       </th>
       <th scope="col">
        Dynamic
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        <a class="link" href="server-options.html#option_mysqld_allow-suspicious-udfs">
         allow-suspicious-udfs
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-system-variables.html#sysvar_automatic_sp_privileges">
         automatic_sp_privileges
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
        Global
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-options.html#option_mysqld_chroot">
         chroot
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-system-variables.html#sysvar_local_infile">
         local_infile
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
        Global
       </td>
       <td>
        Yes
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-options.html#option_mysqld_safe-user-create">
         safe-user-create
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-system-variables.html#sysvar_secure_file_priv">
         secure_file_priv
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
        Global
       </td>
       <td>
        No
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-options.html#option_mysqld_skip-grant-tables">
         skip-grant-tables
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-system-variables.html#sysvar_skip_name_resolve">
         skip_name_resolve
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
        Global
       </td>
       <td>
        No
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-system-variables.html#sysvar_skip_networking">
         skip_networking
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
        Global
       </td>
       <td>
        No
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="server-options.html#option_mysqld_skip-show-database">
         skip_show_database
        </a>
       </th>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
        Yes
       </td>
       <td>
       </td>
       <td>
        Global
       </td>
       <td>
        No
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th scope="col" style="width: 176.875px;">
        Name
       </th>
       <th scope="col" style="width: 96.6562px;">
        Cmd-Line
       </th>
       <th scope="col" style="width: 99.25px;">
        Option File
       </th>
       <th scope="col" style="width: 99.7812px;">
        System Var
       </th>
       <th scope="col" style="width: 98.4531px;">
        Status Var
       </th>
       <th scope="col" style="width: 97.6406px;">
        Var Scope
       </th>
       <th scope="col" style="width: 69.3438px;">
        Dynamic
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
