<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysqlcheck">
      </a>
      6.5.3 mysqlcheck — A Table Maintenance Program
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045315949056">
  </a>
  <a class="indexterm" name="idm46045315948144">
  </a>
  <a class="indexterm" name="idm46045315946784">
  </a>
  <a class="indexterm" name="idm46045315945424">
  </a>
  <a class="indexterm" name="idm46045315944064">
  </a>
  <p>
   The
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   client performs table
        maintenance: It checks, repairs, optimizes, or analyzes tables.
  </p>
  <p>
   Each table is locked and therefore unavailable to other sessions
        while it is being processed, although for check operations, the
        table is locked with a
   <code class="literal">
    READ
   </code>
   lock only (see
   <a class="xref" href="lock-tables.html" title="15.3.6 LOCK TABLES and UNLOCK TABLES Statements">
    Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
   </a>
   , for more information about
   <code class="literal">
    READ
   </code>
   and
   <code class="literal">
    WRITE
   </code>
   locks).
        Table maintenance operations can be time-consuming, particularly
        for large tables. If you use the
   <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
    <code class="option">
     --databases
    </code>
   </a>
   or
   <a class="link" href="mysqlcheck.html#option_mysqlcheck_all-databases">
    <code class="option">
     --all-databases
    </code>
   </a>
   option to
        process all tables in one or more databases, an invocation of
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   might take a long time. (This is
        also true for the MySQL upgrade procedure if it determines that
        table checking is needed because it processes tables the same
        way.)
  </p>
  <p>
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   must be used when the
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   server is running, which means that
        you do not have to stop the server to perform table maintenance.
  </p>
  <p>
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   uses the SQL statements
   <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
    <code class="literal">
     CHECK TABLE
    </code>
   </a>
   ,
   <a class="link" href="repair-table.html" title="15.7.3.5 REPAIR TABLE Statement">
    <code class="literal">
     REPAIR TABLE
    </code>
   </a>
   ,
   <a class="link" href="analyze-table.html" title="15.7.3.1 ANALYZE TABLE Statement">
    <code class="literal">
     ANALYZE TABLE
    </code>
   </a>
   , and
   <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
    <code class="literal">
     OPTIMIZE TABLE
    </code>
   </a>
   in a convenient
        way for the user. It determines which statements to use for the
        operation you want to perform, and then sends the statements to
        the server to be executed. For details about which storage
        engines each statement works with, see the descriptions for
        those statements in
   <a class="xref" href="table-maintenance-statements.html" title="15.7.3 Table Maintenance Statements">
    Section 15.7.3, “Table Maintenance Statements”
   </a>
   .
  </p>
  <p>
   All storage engines do not necessarily support all four
        maintenance operations. In such cases, an error message is
        displayed. For example, if
   <code class="literal">
    test.t
   </code>
   is an
   <code class="literal">
    MEMORY
   </code>
   table, an attempt to check it produces
        this result:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa60776207"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqlcheck</span> test t
test<span class="token punctuation">.</span>t
note     <span class="token punctuation">:</span> The storage engine for the table doesn't support check</code></pre>
  </div>
  <p>
   If
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   is unable to repair a table,
        see
   <a class="xref" href="rebuilding-tables.html" title="3.14 Rebuilding or Repairing Tables or Indexes">
    Section 3.14, “Rebuilding or Repairing Tables or Indexes”
   </a>
   for manual table repair
        strategies. This is the case, for example, for
   <code class="literal">
    InnoDB
   </code>
   tables, which can be checked with
   <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
    <code class="literal">
     CHECK TABLE
    </code>
   </a>
   , but not repaired
        with
   <a class="link" href="repair-table.html" title="15.7.3.5 REPAIR TABLE Statement">
    <code class="literal">
     REPAIR TABLE
    </code>
   </a>
   .
  </p>
  <div class="caution" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Caution
   </div>
   <p>
    It is best to make a backup of a table before performing a
          table repair operation; under some circumstances the operation
          might cause data loss. Possible causes include but are not
          limited to file system errors.
   </p>
  </div>
  <p>
   There are three general ways to invoke
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa76327954"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlcheck <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <em class="replaceable">db_name</em> <span class="token punctuation">[</span><em class="replaceable">tbl_name</em> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">]</span>
mysqlcheck <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <span class="token property">--databases</span> <em class="replaceable">db_name</em> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
mysqlcheck <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <span class="token property">--all-databases</span></code></pre>
  </div>
  <p>
   If you do not name any tables following
   <em class="replaceable">
    <code>
     db_name
    </code>
   </em>
   or if you use the
   <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
    <code class="option">
     --databases
    </code>
   </a>
   or
   <a class="link" href="mysqlcheck.html#option_mysqlcheck_all-databases">
    <code class="option">
     --all-databases
    </code>
   </a>
   option,
        entire databases are checked.
  </p>
  <p>
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   has a special feature compared to
        other client programs. The default behavior of checking tables
        (
   <a class="link" href="mysqlcheck.html#option_mysqlcheck_check">
    <code class="option">
     --check
    </code>
   </a>
   ) can be changed by
        renaming the binary. If you want to have a tool that repairs
        tables by default, you should just make a copy of
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   named
   <span class="command">
    <strong>
     mysqlrepair
    </strong>
   </span>
   , or make a symbolic link to
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   named
   <span class="command">
    <strong>
     mysqlrepair
    </strong>
   </span>
   . If you invoke
   <span class="command">
    <strong>
     mysqlrepair
    </strong>
   </span>
   , it repairs tables.
  </p>
  <p>
   The names shown in the following table can be used to change
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   default behavior.
  </p>
  <div class="informaltable">
   <table summary="Command names that can be used to change mysqlcheck default behavior.">
    <colgroup>
     <col style="width: 25%"/>
     <col style="width: 75%"/>
    </colgroup>
    <thead>
     <tr>
      <th>
       Command
      </th>
      <th>
       Meaning
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <span class="command">
        <strong>
         mysqlrepair
        </strong>
       </span>
      </td>
      <td>
       The default option is
       <a class="link" href="mysqlcheck.html#option_mysqlcheck_repair">
        <code class="option">
         --repair
        </code>
       </a>
      </td>
     </tr>
     <tr>
      <td>
       <span class="command">
        <strong>
         mysqlanalyze
        </strong>
       </span>
      </td>
      <td>
       The default option is
       <a class="link" href="mysqlcheck.html#option_mysqlcheck_analyze">
        <code class="option">
         --analyze
        </code>
       </a>
      </td>
     </tr>
     <tr>
      <td>
       <span class="command">
        <strong>
         mysqloptimize
        </strong>
       </span>
      </td>
      <td>
       The default option is
       <a class="link" href="mysqlcheck.html#option_mysqlcheck_optimize">
        <code class="option">
         --optimize
        </code>
       </a>
      </td>
     </tr>
    </tbody>
   </table>
  </div>
  <p>
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   supports the following options,
        which can be specified on the command line or in the
   <code class="literal">
    [mysqlcheck]
   </code>
   and
   <code class="literal">
    [client]
   </code>
   groups of an option file. For information about option files
        used by MySQL programs, see
   <a class="xref" href="option-files.html" title="6.2.2.2 Using Option Files">
    Section 6.2.2.2, “Using Option Files”
   </a>
   .
  </p>
  <div class="table">
   <a name="idm46045315875328">
   </a>
   <p class="title">
    <b>
     Table 6.12 mysqlcheck Options
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Command-line options available for mysqlcheck.">
     <colgroup>
      <col style="width: 35%"/>
      <col style="width: 64%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Option Name
       </th>
       <th>
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_all-databases">
         --all-databases
        </a>
       </td>
       <td>
        Check all tables in all databases
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_all-in-1">
         --all-in-1
        </a>
       </td>
       <td>
        Execute a single statement for each database that names all the tables from that database
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_analyze">
         --analyze
        </a>
       </td>
       <td>
        Analyze the tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_auto-repair">
         --auto-repair
        </a>
       </td>
       <td>
        If a checked table is corrupted, automatically fix it
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_bind-address">
         --bind-address
        </a>
       </td>
       <td>
        Use specified network interface to connect to MySQL Server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_character-sets-dir">
         --character-sets-dir
        </a>
       </td>
       <td>
        Directory where character sets are installed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_check">
         --check
        </a>
       </td>
       <td>
        Check the tables for errors
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_check-only-changed">
         --check-only-changed
        </a>
       </td>
       <td>
        Check only tables that have changed since the last check
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_check-upgrade">
         --check-upgrade
        </a>
       </td>
       <td>
        Invoke CHECK TABLE with the FOR UPGRADE option
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_compress">
         --compress
        </a>
       </td>
       <td>
        Compress all information sent between client and server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_compression-algorithms">
         --compression-algorithms
        </a>
       </td>
       <td>
        Permitted compression algorithms for connections to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
         --databases
        </a>
       </td>
       <td>
        Interpret all arguments as database names
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_debug">
         --debug
        </a>
       </td>
       <td>
        Write debugging log
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_debug-check">
         --debug-check
        </a>
       </td>
       <td>
        Print debugging information when program exits
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_debug-info">
         --debug-info
        </a>
       </td>
       <td>
        Print debugging information, memory, and CPU statistics when program exits
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_default-auth">
         --default-auth
        </a>
       </td>
       <td>
        Authentication plugin to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_default-character-set">
         --default-character-set
        </a>
       </td>
       <td>
        Specify default character set
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-extra-file">
         --defaults-extra-file
        </a>
       </td>
       <td>
        Read named option file in addition to usual option files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-file">
         --defaults-file
        </a>
       </td>
       <td>
        Read only named option file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-group-suffix">
         --defaults-group-suffix
        </a>
       </td>
       <td>
        Option group suffix value
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_enable-cleartext-plugin">
         --enable-cleartext-plugin
        </a>
       </td>
       <td>
        Enable cleartext authentication plugin
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_extended">
         --extended
        </a>
       </td>
       <td>
        Check and repair tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_fast">
         --fast
        </a>
       </td>
       <td>
        Check only tables that have not been closed properly
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_force">
         --force
        </a>
       </td>
       <td>
        Continue even if an SQL error occurs
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_get-server-public-key">
         --get-server-public-key
        </a>
       </td>
       <td>
        Request RSA public key from server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_help">
         --help
        </a>
       </td>
       <td>
        Display help message and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_host">
         --host
        </a>
       </td>
       <td>
        Host on which MySQL server is located
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_login-path">
         --login-path
        </a>
       </td>
       <td>
        Read login path options from .mylogin.cnf
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_medium-check">
         --medium-check
        </a>
       </td>
       <td>
        Do a check that is faster than an --extended operation
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_no-defaults">
         --no-defaults
        </a>
       </td>
       <td>
        Read no option files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_no-login-paths">
         --no-login-paths
        </a>
       </td>
       <td>
        Do not read login paths from the login path file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_optimize">
         --optimize
        </a>
       </td>
       <td>
        Optimize the tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_password">
         --password
        </a>
       </td>
       <td>
        Password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
         --password1
        </a>
       </td>
       <td>
        First multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_password2">
         --password2
        </a>
       </td>
       <td>
        Second multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_password3">
         --password3
        </a>
       </td>
       <td>
        Third multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_pipe">
         --pipe
        </a>
       </td>
       <td>
        Connect to server using named pipe (Windows only)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_plugin-dir">
         --plugin-dir
        </a>
       </td>
       <td>
        Directory where plugins are installed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_port">
         --port
        </a>
       </td>
       <td>
        TCP/IP port number for connection
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_print-defaults">
         --print-defaults
        </a>
       </td>
       <td>
        Print default options
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_protocol">
         --protocol
        </a>
       </td>
       <td>
        Transport protocol to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_quick">
         --quick
        </a>
       </td>
       <td>
        The fastest method of checking
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_repair">
         --repair
        </a>
       </td>
       <td>
        Perform a repair that can fix almost anything except unique keys that are not unique
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_server-public-key-path">
         --server-public-key-path
        </a>
       </td>
       <td>
        Path name to file containing RSA public key
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_shared-memory-base-name">
         --shared-memory-base-name
        </a>
       </td>
       <td>
        Shared-memory name for shared-memory connections (Windows only)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_silent">
         --silent
        </a>
       </td>
       <td>
        Silent mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_skip-database">
         --skip-database
        </a>
       </td>
       <td>
        Omit this database from performed operations
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_socket">
         --socket
        </a>
       </td>
       <td>
        Unix socket file or Windows named pipe to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-ca
        </a>
       </td>
       <td>
        File that contains list of trusted SSL Certificate Authorities
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-capath
        </a>
       </td>
       <td>
        Directory that contains trusted SSL Certificate Authority certificate files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-cert
        </a>
       </td>
       <td>
        File that contains X.509 certificate
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-cipher
        </a>
       </td>
       <td>
        Permissible ciphers for connection encryption
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-crl
        </a>
       </td>
       <td>
        File that contains certificate revocation lists
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-crlpath
        </a>
       </td>
       <td>
        Directory that contains certificate revocation-list files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl-fips-mode">
         --ssl-fips-mode
        </a>
       </td>
       <td>
        Whether to enable FIPS mode on client side
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-key
        </a>
       </td>
       <td>
        File that contains X.509 key
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-mode
        </a>
       </td>
       <td>
        Desired security state of connection to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-session-data
        </a>
       </td>
       <td>
        File that contains SSL session data
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl">
         --ssl-session-data-continue-on-failed-reuse
        </a>
       </td>
       <td>
        Whether to establish connections if session reuse fails
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_tables">
         --tables
        </a>
       </td>
       <td>
        Overrides the --databases or -B option
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_tls-ciphersuites">
         --tls-ciphersuites
        </a>
       </td>
       <td>
        Permissible TLSv1.3 ciphersuites for encrypted connections
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_tls-sni-servername">
         --tls-sni-servername
        </a>
       </td>
       <td>
        Server name supplied by the client
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_tls-version">
         --tls-version
        </a>
       </td>
       <td>
        Permissible TLS protocols for encrypted connections
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_use-frm">
         --use-frm
        </a>
       </td>
       <td>
        For repair operations on MyISAM tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_user">
         --user
        </a>
       </td>
       <td>
        MySQL user name to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_verbose">
         --verbose
        </a>
       </td>
       <td>
        Verbose mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_version">
         --version
        </a>
       </td>
       <td>
        Display version information and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_write-binlog">
         --write-binlog
        </a>
       </td>
       <td>
        Log ANALYZE, OPTIMIZE, REPAIR statements to binary log. --skip-write-binlog adds NO_WRITE_TO_BINLOG to these statements
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlcheck.html#option_mysqlcheck_zstd-compression-level">
         --zstd-compression-level
        </a>
       </td>
       <td>
        Compression level for connections to server that use zstd compression
       </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 style="width: 260.906px;">
        Option Name
       </th>
       <th style="width: 477.094px;">
        Description
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_help">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_help">
       <code class="option">
        --help
       </code>
      </a>
      ,
      <code class="option">
       -?
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315673440">
     </a>
     <a class="indexterm" name="idm46045315671952">
     </a>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_all-databases">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_all-databases">
       <code class="option">
        --all-databases
       </code>
      </a>
      ,
      <code class="option">
       -A
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for all-databases">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --all-databases
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315661872">
     </a>
     <a class="indexterm" name="idm46045315660384">
     </a>
     <p>
      Check all tables in all databases. This is the same as using
            the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
       <code class="option">
        --databases
       </code>
      </a>
      option
            and naming all the databases on the command line, except
            that the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      and
      <code class="literal">
       performance_schema
      </code>
      databases are not
            checked. They can be checked by explicitly naming them with
            the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
       <code class="option">
        --databases
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_all-in-1">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_all-in-1">
       <code class="option">
        --all-in-1
       </code>
      </a>
      ,
      <code class="option">
       -1
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for all-in-1">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --all-in-1
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315646640">
     </a>
     <a class="indexterm" name="idm46045315645152">
     </a>
     <p>
      Instead of issuing a statement for each table, execute a
            single statement for each database that names all the tables
            from that database to be processed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_analyze">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_analyze">
       <code class="option">
        --analyze
       </code>
      </a>
      ,
      <code class="option">
       -a
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for analyze">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --analyze
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315635008">
     </a>
     <a class="indexterm" name="idm46045315633520">
     </a>
     <p>
      Analyze the tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_auto-repair">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_auto-repair">
       <code class="option">
        --auto-repair
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-repair">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-repair
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315623920">
     </a>
     <a class="indexterm" name="idm46045315622432">
     </a>
     <p>
      If a checked table is corrupted, automatically fix it. Any
            necessary repairs are done after all tables have been
            checked.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_bind-address">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_bind-address">
       <code class="option">
        --bind-address=
        <em class="replaceable">
         <code>
          ip_address
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for bind-address">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --bind-address=ip_address
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315612352">
     </a>
     <a class="indexterm" name="idm46045315610864">
     </a>
     <p>
      On a computer having multiple network interfaces, use this
            option to select which interface to use for connecting to
            the MySQL server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_character-sets-dir">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_character-sets-dir">
       <code class="option">
        --character-sets-dir=
        <em class="replaceable">
         <code>
          dir_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for character-sets-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --character-sets-dir=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315598736">
     </a>
     <a class="indexterm" name="idm46045315597232">
     </a>
     <p>
      The directory where character sets are installed. See
      <a class="xref" href="charset-configuration.html" title="12.15 Character Set Configuration">
       Section 12.15, “Character Set Configuration”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_check">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_check">
       <code class="option">
        --check
       </code>
      </a>
      ,
      <code class="option">
       -c
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --check
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315586528">
     </a>
     <a class="indexterm" name="idm46045315585040">
     </a>
     <p>
      Check the tables for errors. This is the default operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_check-only-changed">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_check-only-changed">
       <code class="option">
        --check-only-changed
       </code>
      </a>
      ,
      <code class="option">
       -C
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for check-only-changed">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --check-only-changed
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315574944">
     </a>
     <a class="indexterm" name="idm46045315573440">
     </a>
     <p>
      Check only tables that have changed since the last check or
            that have not been closed properly.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_check-upgrade">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_check-upgrade">
       <code class="option">
        --check-upgrade
       </code>
      </a>
      ,
      <code class="option">
       -g
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for check-upgrade">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --check-upgrade
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315563280">
     </a>
     <a class="indexterm" name="idm46045315561792">
     </a>
     <p>
      Invoke
      <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
       <code class="literal">
        CHECK TABLE
       </code>
      </a>
      with the
      <code class="literal">
       FOR UPGRADE
      </code>
      option to check tables for
            incompatibilities with the current version of the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_compress">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_compress">
       <code class="option">
        --compress
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for compress">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --compress[={OFF|ON}]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Deprecated
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           OFF
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315543616">
     </a>
     <a class="indexterm" name="idm46045315542128">
     </a>
     <p>
      Compress all information sent between the client and the
            server if possible. See
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
     <p>
      This option is deprecated. Expect it to be removed in a
            future version of MySQL. See
      <a class="xref" href="connection-compression-control.html#connection-compression-legacy-configuration" title="Configuring Legacy Connection Compression">
       Configuring Legacy Connection Compression
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_compression-algorithms">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_compression-algorithms">
       <code class="option">
        --compression-algorithms=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for compression-algorithms">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --compression-algorithms=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Set
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           uncompressed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            zlib
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            zstd
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            uncompressed
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315520816">
     </a>
     <a class="indexterm" name="idm46045315519312">
     </a>
     <p>
      The permitted compression algorithms for connections to the
            server. The available algorithms are the same as for the
      <a class="link" href="server-system-variables.html#sysvar_protocol_compression_algorithms">
       <code class="literal">
        protocol_compression_algorithms
       </code>
      </a>
      system variable. The default value is
      <code class="literal">
       uncompressed
      </code>
      .
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_databases">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
       <code class="option">
        --databases
       </code>
      </a>
      ,
      <code class="option">
       -B
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for databases">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --databases
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315505984">
     </a>
     <a class="indexterm" name="idm46045315504496">
     </a>
     <p>
      Process all tables in the named databases. Normally,
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      treats the first name argument
            on the command line as a database name and any following
            names as table names. With this option, it treats all name
            arguments as database names.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_debug">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_debug">
       <code class="option">
        --debug[=
        <em class="replaceable">
         <code>
          debug_options
         </code>
        </em>
        ]
       </code>
      </a>
      ,
      <code class="option">
       -#
            [
       <em class="replaceable">
        <code>
         debug_options
        </code>
       </em>
       ]
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for debug">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --debug[=debug_options]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           d:t:o
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315487680">
     </a>
     <a class="indexterm" name="idm46045315486192">
     </a>
     <p>
      Write a debugging log. A typical
      <em class="replaceable">
       <code>
        debug_options
       </code>
      </em>
      string is
      <code class="literal">
       d:t:o,
       <em class="replaceable">
        <code>
         file_name
        </code>
       </em>
      </code>
      .
            The default is
      <code class="literal">
       d:t:o
      </code>
      .
     </p>
     <p>
      This option is available only if MySQL was built using
      <a class="link" href="source-configuration-options.html#option_cmake_with_debug">
       <code class="option">
        WITH_DEBUG
       </code>
      </a>
      . MySQL release
            binaries provided by Oracle are
      <span class="emphasis">
       <em>
        not
       </em>
      </span>
      built using this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_debug-check">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_debug-check">
       <code class="option">
        --debug-check
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for debug-check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --debug-check
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315467904">
     </a>
     <a class="indexterm" name="idm46045315466416">
     </a>
     <p>
      Print some debugging information when the program exits.
     </p>
     <p>
      This option is available only if MySQL was built using
      <a class="link" href="source-configuration-options.html#option_cmake_with_debug">
       <code class="option">
        WITH_DEBUG
       </code>
      </a>
      . MySQL release
            binaries provided by Oracle are
      <span class="emphasis">
       <em>
        not
       </em>
      </span>
      built using this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_debug-info">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_debug-info">
       <code class="option">
        --debug-info
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for debug-info">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --debug-info
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315450304">
     </a>
     <a class="indexterm" name="idm46045315448816">
     </a>
     <p>
      Print debugging information and memory and CPU usage
            statistics when the program exits.
     </p>
     <p>
      This option is available only if MySQL was built using
      <a class="link" href="source-configuration-options.html#option_cmake_with_debug">
       <code class="option">
        WITH_DEBUG
       </code>
      </a>
      . MySQL release
            binaries provided by Oracle are
      <span class="emphasis">
       <em>
        not
       </em>
      </span>
      built using this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_default-character-set">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_default-character-set">
       <code class="option">
        --default-character-set=
        <em class="replaceable">
         <code>
          charset_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for default-character-set">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --default-character-set=charset_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315434784">
     </a>
     <a class="indexterm" name="idm46045315433280">
     </a>
     <p>
      Use
      <em class="replaceable">
       <code>
        charset_name
       </code>
      </em>
      as the default
            character set. See
      <a class="xref" href="charset-configuration.html" title="12.15 Character Set Configuration">
       Section 12.15, “Character Set Configuration”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_defaults-extra-file">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-extra-file">
       <code class="option">
        --defaults-extra-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-extra-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-extra-file=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315420144">
     </a>
     <a class="indexterm" name="idm46045315418640">
     </a>
     <p>
      Read this option file after the global option file but (on
            Unix) before the user option file. If the file does not
            exist or is otherwise inaccessible, an error occurs. If
      <em class="replaceable">
       <code>
        file_name
       </code>
      </em>
      is not an absolute path
            name, it is interpreted relative to the current directory.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_defaults-file">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-file">
       <code class="option">
        --defaults-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-file=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315404736">
     </a>
     <a class="indexterm" name="idm46045315403248">
     </a>
     <p>
      Use only the given option file. If the file does not exist
            or is otherwise inaccessible, an error occurs. If
      <em class="replaceable">
       <code>
        file_name
       </code>
      </em>
      is not an absolute path
            name, it is interpreted relative to the current directory.
     </p>
     <p>
      Exception: Even with
      <a class="link" href="option-file-options.html#option_general_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
      , client
            programs read
      <code class="filename">
       .mylogin.cnf
      </code>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_defaults-group-suffix">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=
        <em class="replaceable">
         <code>
          str
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-group-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-group-suffix=str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315387280">
     </a>
     <a class="indexterm" name="idm46045315385776">
     </a>
     <p>
      Read not only the usual option groups, but also groups with
            the usual names and a suffix of
      <em class="replaceable">
       <code>
        str
       </code>
      </em>
      . For example,
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      normally reads the
      <code class="literal">
       [client]
      </code>
      and
      <code class="literal">
       [mysqlcheck]
      </code>
      groups. If this option is
            given as
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=_other
       </code>
      </a>
      ,
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      also reads the
      <code class="literal">
       [client_other]
      </code>
      and
      <code class="literal">
       [mysqlcheck_other]
      </code>
      groups.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_extended">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_extended">
       <code class="option">
        --extended
       </code>
      </a>
      ,
      <code class="option">
       -e
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for extended">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --extended
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315367552">
     </a>
     <a class="indexterm" name="idm46045315366064">
     </a>
     <p>
      If you are using this option to check tables, it ensures
            that they are 100% consistent but takes a long time.
     </p>
     <p>
      If you are using this option to repair tables, it runs an
            extended repair that may not only take a long time to
            execute, but may produce a lot of garbage rows also!
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_default-auth">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_default-auth">
       <code class="option">
        --default-auth=
        <em class="replaceable">
         <code>
          plugin
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for default-auth">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --default-auth=plugin
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315353424">
     </a>
     <a class="indexterm" name="idm46045315351936">
     </a>
     <p>
      A hint about which client-side authentication plugin to use.
            See
      <a class="xref" href="pluggable-authentication.html" title="8.2.17 Pluggable Authentication">
       Section 8.2.17, “Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_enable-cleartext-plugin">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_enable-cleartext-plugin">
       <code class="option">
        --enable-cleartext-plugin
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for enable-cleartext-plugin">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --enable-cleartext-plugin
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315336880">
     </a>
     <a class="indexterm" name="idm46045315335376">
     </a>
     <p>
      Enable the
      <code class="literal">
       mysql_clear_password
      </code>
      cleartext
            authentication plugin. (See
      <a class="xref" href="cleartext-pluggable-authentication.html" title="8.4.1.4 Client-Side Cleartext Pluggable Authentication">
       Section 8.4.1.4, “Client-Side Cleartext Pluggable Authentication”
      </a>
      .)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_fast">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_fast">
       <code class="option">
        --fast
       </code>
      </a>
      ,
      <code class="option">
       -F
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for fast">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --fast
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315323984">
     </a>
     <a class="indexterm" name="idm46045315322496">
     </a>
     <p>
      Check only tables that have not been closed properly.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_force">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_force">
       <code class="option">
        --force
       </code>
      </a>
      ,
      <code class="option">
       -f
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for force">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --force
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315312480">
     </a>
     <a class="indexterm" name="idm46045315310992">
     </a>
     <p>
      Continue even if an SQL error occurs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_get-server-public-key">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_get-server-public-key">
       <code class="option">
        --get-server-public-key
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for get-server-public-key">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --get-server-public-key
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315299280">
     </a>
     <a class="indexterm" name="idm46045315297776">
     </a>
     <p>
      Request from the server the public key required for RSA key
            pair-based password exchange. This option applies to clients
            that authenticate with the
      <code class="literal">
       caching_sha2_password
      </code>
      authentication
            plugin. For that plugin, the server does not send the public
            key unless requested. This option is ignored for accounts
            that do not authenticate with that plugin. It is also
            ignored if RSA-based password exchange is not used, as is
            the case when the client connects to the server using a
            secure connection.
     </p>
     <p>
      If
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_server-public-key-path">
       <code class="option">
        --server-public-key-path=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      is given and specifies a valid public key file, it takes
            precedence over
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_get-server-public-key">
       <code class="option">
        --get-server-public-key
       </code>
      </a>
      .
     </p>
     <p>
      For information about the
      <code class="literal">
       caching_sha2_password
      </code>
      plugin, see
      <a class="xref" href="caching-sha2-pluggable-authentication.html" title="8.4.1.2 Caching SHA-2 Pluggable Authentication">
       Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_host">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_host">
       <code class="option">
        --host=
        <em class="replaceable">
         <code>
          host_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -h
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --host=host_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           localhost
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315276720">
     </a>
     <a class="indexterm" name="idm46045315275232">
     </a>
     <p>
      Connect to the MySQL server on the given host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_login-path">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_login-path">
       <code class="option">
        --login-path=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for login-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --login-path=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315263232">
     </a>
     <a class="indexterm" name="idm46045315261744">
     </a>
     <p>
      Read options from the named login path in the
      <code class="filename">
       .mylogin.cnf
      </code>
      login path file. A
      <span class="quote">
       “
       <span class="quote">
        login path
       </span>
       ”
      </span>
      is an option group containing
            options that specify which MySQL server to connect to and
            which account to authenticate as. To create or modify a
            login path file, use the
      <a class="link" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       <span class="command">
        <strong>
         mysql_config_editor
        </strong>
       </span>
      </a>
      utility. See
      <a class="xref" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
      </a>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_no-login-paths">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-login-paths">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-login-paths
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315247600">
     </a>
     <a class="indexterm" name="idm46045315246112">
     </a>
     <p>
      Skips reading options from the login path file.
     </p>
     <p>
      See
      <a class="link" href="mysql-command-options.html#option_mysql_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
      for related
            information.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_medium-check">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_medium-check">
       <code class="option">
        --medium-check
       </code>
      </a>
      ,
      <code class="option">
       -m
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for medium-check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --medium-check
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315233456">
     </a>
     <a class="indexterm" name="idm46045315231968">
     </a>
     <p>
      Do a check that is faster than an
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_extended">
       <code class="option">
        --extended
       </code>
      </a>
      operation.
            This finds only 99.99% of all errors, which should be good
            enough in most cases.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_no-defaults">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315221200">
     </a>
     <a class="indexterm" name="idm46045315219712">
     </a>
     <p>
      Do not read any option files. If program startup fails due
            to reading unknown options from an option file,
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
      can be used
            to prevent them from being read.
     </p>
     <p>
      The exception is that the
      <code class="filename">
       .mylogin.cnf
      </code>
      file is read in all cases, if it exists. This permits
            passwords to be specified in a safer way than on the command
            line even when
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
      is used. To
            create
      <code class="filename">
       .mylogin.cnf
      </code>
      , use the
      <a class="link" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       <span class="command">
        <strong>
         mysql_config_editor
        </strong>
       </span>
      </a>
      utility. See
      <a class="xref" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
      </a>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_optimize">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_optimize">
       <code class="option">
        --optimize
       </code>
      </a>
      ,
      <code class="option">
       -o
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for optimize">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --optimize
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315202352">
     </a>
     <a class="indexterm" name="idm46045315200864">
     </a>
     <p>
      Optimize the tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_password">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password">
       <code class="option">
        --password[=
        <em class="replaceable">
         <code>
          password
         </code>
        </em>
        ]
       </code>
      </a>
      ,
      <code class="option">
       -p[
       <em class="replaceable">
        <code>
         password
        </code>
       </em>
       ]
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for password">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --password[=password]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315187936">
     </a>
     <a class="indexterm" name="idm46045315186448">
     </a>
     <p>
      The password of the MySQL account used for connecting to the
            server. The password value is optional. If not given,
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      prompts for one. If given,
            there must be
      <span class="emphasis">
       <em>
        no space
       </em>
      </span>
      between
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password">
       <code class="option">
        --password=
       </code>
      </a>
      or
      <code class="option">
       -p
      </code>
      and the password following it. If no
            password option is specified, the default is to send no
            password.
     </p>
     <p>
      Specifying a password on the command line should be
            considered insecure. To avoid giving the password on the
            command line, use an option file. See
      <a class="xref" href="password-security-user.html" title="8.1.2.1 End-User Guidelines for Password Security">
       Section 8.1.2.1, “End-User Guidelines for Password Security”
      </a>
      .
     </p>
     <p>
      To explicitly specify that there is no password and that
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      should not prompt for one, use
            the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_password1">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --password1[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045315174512">
     </a>
     <p>
      The password for multifactor authentication factor 1 of the
            MySQL account used for connecting to the server. The
            password value is optional. If not given,
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      prompts for one. If given,
            there must be
      <span class="emphasis">
       <em>
        no space
       </em>
      </span>
      between
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --password1=
       </code>
      </a>
      and the
            password following it. If no password option is specified,
            the default is to send no password.
     </p>
     <p>
      Specifying a password on the command line should be
            considered insecure. To avoid giving the password on the
            command line, use an option file. See
      <a class="xref" href="password-security-user.html" title="8.1.2.1 End-User Guidelines for Password Security">
       Section 8.1.2.1, “End-User Guidelines for Password Security”
      </a>
      .
     </p>
     <p>
      To explicitly specify that there is no password and that
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      should not prompt for one, use
            the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      option.
     </p>
     <p>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --password1
       </code>
      </a>
      and
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password">
       <code class="option">
        --password
       </code>
      </a>
      are
            synonymous, as are
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      and
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_password2">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password2">
       <code class="option">
        --password2[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045315158960">
     </a>
     <p>
      The password for multifactor authentication factor 2 of the
            MySQL account used for connecting to the server. The
            semantics of this option are similar to the semantics for
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_password3">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password3">
       <code class="option">
        --password3[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045315153600">
     </a>
     <p>
      The password for multifactor authentication factor 3 of the
            MySQL account used for connecting to the server. The
            semantics of this option are similar to the semantics for
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_pipe">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_pipe">
       <code class="option">
        --pipe
       </code>
      </a>
      ,
      <code class="option">
       -W
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pipe">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pipe
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315140800">
     </a>
     <a class="indexterm" name="idm46045315139312">
     </a>
     <p>
      On Windows, connect to the server using a named pipe. This
            option applies only if the server was started with the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe">
       <code class="literal">
        named_pipe
       </code>
      </a>
      system variable
            enabled to support named-pipe connections. In addition, the
            user making the connection must be a member of the Windows
            group specified by the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe_full_access_group">
       <code class="literal">
        named_pipe_full_access_group
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_plugin-dir">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_plugin-dir">
       <code class="option">
        --plugin-dir=
        <em class="replaceable">
         <code>
          dir_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for plugin-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --plugin-dir=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315124496">
     </a>
     <a class="indexterm" name="idm46045315123008">
     </a>
     <p>
      The directory in which to look for plugins. Specify this
            option if the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_default-auth">
       <code class="option">
        --default-auth
       </code>
      </a>
      option is
            used to specify an authentication plugin but
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      does not find it. See
      <a class="xref" href="pluggable-authentication.html" title="8.2.17 Pluggable Authentication">
       Section 8.2.17, “Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_port">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_port">
       <code class="option">
        --port=
        <em class="replaceable">
         <code>
          port_num
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -P
       <em class="replaceable">
        <code>
         port_num
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for port">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --port=port_num
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           3306
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315104880">
     </a>
     <a class="indexterm" name="idm46045315103392">
     </a>
     <p>
      For TCP/IP connections, the port number to use.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_print-defaults">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for print-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --print-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315093728">
     </a>
     <a class="indexterm" name="idm46045315092240">
     </a>
     <p>
      Print the program name and all options that it gets from
            option files.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_protocol">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_protocol">
       <code class="option">
        --protocol={TCP|SOCKET|PIPE|MEMORY}
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for protocol">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --protocol=type
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [see text]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            TCP
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            SOCKET
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            PIPE
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            MEMORY
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315071168">
     </a>
     <a class="indexterm" name="idm46045315069680">
     </a>
     <p>
      The transport protocol to use for connecting to the server.
            It is useful when the other connection parameters normally
            result in use of a protocol other than the one you want. For
            details on the permissible values, see
      <a class="xref" href="transport-protocols.html" title="6.2.7 Connection Transport Protocols">
       Section 6.2.7, “Connection Transport Protocols”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_quick">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_quick">
       <code class="option">
        --quick
       </code>
      </a>
      ,
      <code class="option">
       -q
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for quick">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --quick
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315058784">
     </a>
     <a class="indexterm" name="idm46045315057296">
     </a>
     <p>
      If you are using this option to check tables, it prevents
            the check from scanning the rows to check for incorrect
            links. This is the fastest check method.
     </p>
     <p>
      If you are using this option to repair tables, it tries to
            repair only the index tree. This is the fastest repair
            method.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_repair">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_repair">
       <code class="option">
        --repair
       </code>
      </a>
      ,
      <code class="option">
       -r
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for repair">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --repair
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315046464">
     </a>
     <a class="indexterm" name="idm46045315044976">
     </a>
     <p>
      Perform a repair that can fix almost anything except unique
            keys that are not unique.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_server-public-key-path">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_server-public-key-path">
       <code class="option">
        --server-public-key-path=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for server-public-key-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --server-public-key-path=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315032800">
     </a>
     <a class="indexterm" name="idm46045315031296">
     </a>
     <p>
      The path name to a file in PEM format containing a
            client-side copy of the public key required by the server
            for RSA key pair-based password exchange. This option
            applies to clients that authenticate with the
      <code class="literal">
       sha256_password
      </code>
      (deprecated) or
      <code class="literal">
       caching_sha2_password
      </code>
      authentication
            plugin. This option is ignored for accounts that do not
            authenticate with one of those plugins. It is also ignored
            if RSA-based password exchange is not used, as is the case
            when the client connects to the server using a secure
            connection.
     </p>
     <p>
      If
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_server-public-key-path">
       <code class="option">
        --server-public-key-path=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      is given and specifies a valid public key file, it takes
            precedence over
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_get-server-public-key">
       <code class="option">
        --get-server-public-key
       </code>
      </a>
      .
     </p>
     <p>
      For
      <code class="literal">
       sha256_password
      </code>
      (deprecated), this
            option applies only if MySQL was built using OpenSSL.
     </p>
     <p>
      For information about the
      <code class="literal">
       sha256_password
      </code>
      and
      <code class="literal">
       caching_sha2_password
      </code>
      plugins, see
      <a class="xref" href="sha256-pluggable-authentication.html" title="8.4.1.3 SHA-256 Pluggable Authentication">
       Section 8.4.1.3, “SHA-256 Pluggable Authentication”
      </a>
      , and
      <a class="xref" href="caching-sha2-pluggable-authentication.html" title="8.4.1.2 Caching SHA-2 Pluggable Authentication">
       Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_shared-memory-base-name">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_shared-memory-base-name">
       <code class="option">
        --shared-memory-base-name=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for shared-memory-base-name">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --shared-memory-base-name=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Platform Specific
         </th>
         <td>
          Windows
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315009856">
     </a>
     <a class="indexterm" name="idm46045315008352">
     </a>
     <p>
      On Windows, the shared-memory name to use for connections
            made using shared memory to a local server. The default
            value is
      <code class="literal">
       MYSQL
      </code>
      . The shared-memory name is
            case-sensitive.
     </p>
     <p>
      This option applies only if the server was started with the
      <a class="link" href="server-system-variables.html#sysvar_shared_memory">
       <code class="literal">
        shared_memory
       </code>
      </a>
      system
            variable enabled to support shared-memory connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_silent">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_silent">
       <code class="option">
        --silent
       </code>
      </a>
      ,
      <code class="option">
       -s
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for silent">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --silent
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314995648">
     </a>
     <a class="indexterm" name="idm46045314994160">
     </a>
     <p>
      Silent mode. Print only error messages.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_skip-database">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_skip-database">
       <code class="option">
        --skip-database=
        <em class="replaceable">
         <code>
          db_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for skip-database">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --skip-database=db_name
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314984320">
     </a>
     <a class="indexterm" name="idm46045314982832">
     </a>
     <p>
      Do not include the named database (case-sensitive) in the
            operations performed by
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_socket">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_socket">
       <code class="option">
        --socket=
        <em class="replaceable">
         <code>
          path
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -S
       <em class="replaceable">
        <code>
         path
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for socket">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --socket={file_name|pipe_name}
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314968848">
     </a>
     <a class="indexterm" name="idm46045314967360">
     </a>
     <p>
      For connections to
      <code class="literal">
       localhost
      </code>
      , the Unix
            socket file to use, or, on Windows, the name of the named
            pipe to use.
     </p>
     <p>
      On Windows, this option applies only if the server was
            started with the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe">
       <code class="literal">
        named_pipe
       </code>
      </a>
      system variable enabled to support named-pipe connections.
            In addition, the user making the connection must be a member
            of the Windows group specified by the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe_full_access_group">
       <code class="literal">
        named_pipe_full_access_group
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_ssl">
      </a>
      <code class="option">
       --ssl*
      </code>
     </p>
     <a class="indexterm" name="idm46045314959776">
     </a>
     <a class="indexterm" name="idm46045314958288">
     </a>
     <p>
      Options that begin with
      <code class="option">
       --ssl
      </code>
      specify
            whether to connect to the server using encryption and
            indicate where to find SSL keys and certificates. See
      <a class="xref" href="connection-options.html#encrypted-connection-options" title="Command Options for Encrypted Connections">
       Command Options for Encrypted Connections
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_ssl-fips-mode">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl-fips-mode">
       <code class="option">
        --ssl-fips-mode={OFF|ON|STRICT}
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ssl-fips-mode">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ssl-fips-mode={OFF|ON|STRICT}
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Deprecated
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           OFF
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            OFF
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            ON
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            STRICT
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314936144">
     </a>
     <a class="indexterm" name="idm46045314934656">
     </a>
     <p>
      Controls whether to enable FIPS mode on the client side. The
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl-fips-mode">
       <code class="option">
        --ssl-fips-mode
       </code>
      </a>
      option
            differs from other
      <code class="option">
       --ssl-
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      options in that it is not used to establish encrypted
            connections, but rather to affect which cryptographic
            operations to permit. See
      <a class="xref" href="fips-mode.html" title="8.8 FIPS Support">
       Section 8.8, “FIPS Support”
      </a>
      .
     </p>
     <p>
      These
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl-fips-mode">
       <code class="option">
        --ssl-fips-mode
       </code>
      </a>
      values are permitted:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          OFF
         </code>
         : Disable FIPS mode.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          ON
         </code>
         : Enable FIPS mode.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          STRICT
         </code>
         : Enable
         <span class="quote">
          “
          <span class="quote">
           strict
          </span>
          ”
         </span>
         FIPS mode.
        </p>
       </li>
      </ul>
     </div>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       If the OpenSSL FIPS Object Module is not available, the
              only permitted value for
       <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl-fips-mode">
        <code class="option">
         --ssl-fips-mode
        </code>
       </a>
       is
       <code class="literal">
        OFF
       </code>
       . In this case, setting
       <a class="link" href="mysqlcheck.html#option_mysqlcheck_ssl-fips-mode">
        <code class="option">
         --ssl-fips-mode
        </code>
       </a>
       to
       <code class="literal">
        ON
       </code>
       or
       <code class="literal">
        STRICT
       </code>
       causes
              the client to produce a warning at startup and to operate
              in non-FIPS mode.
      </p>
     </div>
     <p>
      This option is deprecated. Expect it to be removed in a
            future version of MySQL.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_tables">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_tables">
       <code class="option">
        --tables
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tables">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tables
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314910016">
     </a>
     <a class="indexterm" name="idm46045314908528">
     </a>
     <p>
      Override the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_databases">
       <code class="option">
        --databases
       </code>
      </a>
      or
      <code class="option">
       -B
      </code>
      option. All name arguments following
            the option are regarded as table names.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_tls-ciphersuites">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_tls-ciphersuites">
       <code class="option">
        --tls-ciphersuites=
        <em class="replaceable">
         <code>
          ciphersuite_list
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tls-ciphersuites">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tls-ciphersuites=ciphersuite_list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314895104">
     </a>
     <a class="indexterm" name="idm46045314893616">
     </a>
     <p>
      The permissible ciphersuites for encrypted connections that
            use TLSv1.3. The value is a list of one or more
            colon-separated ciphersuite names. The ciphersuites that can
            be named for this option depend on the SSL library used to
            compile MySQL. For details, see
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_tls-sni-servername">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_tls-sni-servername">
       <code class="option">
        --tls-sni-servername=
        <em class="replaceable">
         <code>
          server_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tls-sni-servername">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tls-sni-servername=server_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314880624">
     </a>
     <a class="indexterm" name="idm46045314879120">
     </a>
     <p>
      When specified, the name is passed to the
      <code class="literal">
       libmysqlclient
      </code>
      C API library using the
      <code class="literal">
       MYSQL_OPT_TLS_SNI_SERVERNAME
      </code>
      option of
      <a class="ulink" href="/doc/c-api/8.4/en/mysql-options.html" target="_top">
       <code class="literal">
        mysql_options()
       </code>
      </a>
      . The server
            name is not case-sensitive. To show which server name the
            client specified for the current session, if any, check the
      <a class="link" href="server-status-variables.html#statvar_Tls_sni_server_name">
       <code class="literal">
        Tls_sni_server_name
       </code>
      </a>
      status
            variable.
     </p>
     <p>
      Server Name Indication (SNI) is an extension to the TLS
            protocol (OpenSSL must be compiled using TLS extensions for
            this option to function). The MySQL implementation of SNI
            represents the client-side only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_tls-version">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_tls-version">
       <code class="option">
        --tls-version=
        <em class="replaceable">
         <code>
          protocol_list
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tls-version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tls-version=protocol_list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
           </code>
           (OpenSSL 1.1.1 or higher)
          </p>
          <p class="valid-value">
           <code class="literal">
            TLSv1,TLSv1.1,TLSv1.2
           </code>
           (otherwise)
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314858176">
     </a>
     <a class="indexterm" name="idm46045314856688">
     </a>
     <p>
      The permissible TLS protocols for encrypted connections. The
            value is a list of one or more comma-separated protocol
            names. The protocols that can be named for this option
            depend on the SSL library used to compile MySQL. For
            details, see
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_use-frm">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_use-frm">
       <code class="option">
        --use-frm
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for use-frm">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --use-frm
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314846048">
     </a>
     <a class="indexterm" name="idm46045314844560">
     </a>
     <p>
      For repair operations on
      <code class="literal">
       MyISAM
      </code>
      tables,
            get the table structure from the data dictionary so that the
            table can be repaired even if the
      <code class="filename">
       .MYI
      </code>
      header is corrupted.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_user">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_user">
       <code class="option">
        --user=
        <em class="replaceable">
         <code>
          user_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -u
       <em class="replaceable">
        <code>
         user_name
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for user">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --user=user_name,
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314830432">
     </a>
     <a class="indexterm" name="idm46045314828944">
     </a>
     <p>
      The user name of the MySQL account to use for connecting to
            the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_verbose">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
      ,
      <code class="option">
       -v
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for verbose">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --verbose
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314818784">
     </a>
     <a class="indexterm" name="idm46045314817296">
     </a>
     <p>
      Verbose mode. Print information about the various stages of
            program operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_version">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_version">
       <code class="option">
        --version
       </code>
      </a>
      ,
      <code class="option">
       -V
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --version
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314807184">
     </a>
     <a class="indexterm" name="idm46045314805696">
     </a>
     <p>
      Display version information and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_write-binlog">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_write-binlog">
       <code class="option">
        --write-binlog
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for write-binlog">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --write-binlog
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314796080">
     </a>
     <a class="indexterm" name="idm46045314794592">
     </a>
     <p>
      This option is enabled by default, so that
      <a class="link" href="analyze-table.html" title="15.7.3.1 ANALYZE TABLE Statement">
       <code class="literal">
        ANALYZE TABLE
       </code>
      </a>
      ,
      <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
       <code class="literal">
        OPTIMIZE TABLE
       </code>
      </a>
      , and
      <a class="link" href="repair-table.html" title="15.7.3.5 REPAIR TABLE Statement">
       <code class="literal">
        REPAIR TABLE
       </code>
      </a>
      statements
            generated by
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
      are written to
            the binary log. Use
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_write-binlog">
       <code class="option">
        --skip-write-binlog
       </code>
      </a>
      to cause
      <code class="literal">
       NO_WRITE_TO_BINLOG
      </code>
      to be added
            to the statements so that they are not logged. Use the
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_write-binlog">
       <code class="option">
        --skip-write-binlog
       </code>
      </a>
      when these statements should not be sent to replicas or run
            when using the binary logs for recovery from backup.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlcheck_zstd-compression-level">
      </a>
      <a class="link" href="mysqlcheck.html#option_mysqlcheck_zstd-compression-level">
       <code class="option">
        --zstd-compression-level=
        <em class="replaceable">
         <code>
          level
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for zstd-compression-level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --zstd-compression-level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045314774528">
     </a>
     <a class="indexterm" name="idm46045314773024">
     </a>
     <p>
      The compression level to use for connections to the server
            that use the
      <code class="literal">
       zstd
      </code>
      compression algorithm.
            The permitted levels are from 1 to 22, with larger values
            indicating increasing levels of compression. The default
      <code class="literal">
       zstd
      </code>
      compression level is 3. The
            compression level setting has no effect on connections that
            do not use
      <code class="literal">
       zstd
      </code>
      compression.
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
