<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysqladmin">
      </a>
      6.5.2 mysqladmin — A MySQL Server Administration Program
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045317096016">
  </a>
  <a class="indexterm" name="idm46045317095104">
  </a>
  <a class="indexterm" name="idm46045317093744">
  </a>
  <p>
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin
     </strong>
    </span>
   </a>
   is a client for performing
        administrative operations. You can use it to check the server's
        configuration and current status, to create and drop databases,
        and more.
  </p>
  <p>
   Invoke
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa67669590"><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">mysqladmin <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <em class="replaceable">command</em> <span class="token punctuation">[</span><em class="replaceable">command-arg</em><span class="token punctuation">]</span> <span class="token punctuation">[</span><em class="replaceable">command</em> <span class="token punctuation">[</span><em class="replaceable">command-arg</em><span class="token punctuation">]</span><span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></code></pre>
  </div>
  <p>
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin
     </strong>
    </span>
   </a>
   supports the following commands.
        Some of the commands take an argument following the command
        name.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_db_name">
      </a>
      <code class="literal">
       create
       <em class="replaceable">
        <code>
         db_name
        </code>
       </em>
      </code>
     </p>
     <p>
      Create a new database named
      <em class="replaceable">
       <code>
        db_name
       </code>
      </em>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_debug">
      </a>
      <code class="literal">
       debug
      </code>
     </p>
     <p>
      Tells the server to write debug information to the error
            log. The connected user must have the
      <a class="link" href="privileges-provided.html#priv_super">
       <code class="literal">
        SUPER
       </code>
      </a>
      privilege. Format and
            content of this information is subject to change.
     </p>
     <p>
      This includes information about the Event Scheduler. See
      <a class="xref" href="events-status-info.html" title="27.4.5 Event Scheduler Status">
       Section 27.4.5, “Event Scheduler Status”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_drop">
      </a>
      <code class="literal">
       drop
       <em class="replaceable">
        <code>
         db_name
        </code>
       </em>
      </code>
     </p>
     <p>
      Delete the database named
      <em class="replaceable">
       <code>
        db_name
       </code>
      </em>
      and all its tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_extended-status">
      </a>
      <code class="literal">
       extended-status
      </code>
     </p>
     <p>
      Display the server status variables and their values.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_flush-hosts">
      </a>
      <code class="literal">
       flush-hosts
      </code>
     </p>
     <p>
      Flush all information in the host cache. See
      <a class="xref" href="host-cache.html" title="7.1.12.3 DNS Lookups and the Host Cache">
       Section 7.1.12.3, “DNS Lookups and the Host Cache”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_flush-logs">
      </a>
      <code class="literal">
       flush-logs [
       <em class="replaceable">
        <code>
         log_type
        </code>
       </em>
       ...]
      </code>
     </p>
     <p>
      Flush all logs.
     </p>
     <p>
      The
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin flush-logs
        </strong>
       </span>
      </a>
      command permits
            optional log types to be given, to specify which logs to
            flush. Following the
      <code class="literal">
       flush-logs
      </code>
      command,
            you can provide a space-separated list of one or more of the
            following log types:
      <code class="literal">
       binary
      </code>
      ,
      <code class="literal">
       engine
      </code>
      ,
      <code class="literal">
       error
      </code>
      ,
      <code class="literal">
       general
      </code>
      ,
      <code class="literal">
       relay
      </code>
      ,
      <code class="literal">
       slow
      </code>
      . These correspond to the log types
            that can be specified for the
      <a class="link" href="flush.html#flush-logs">
       <code class="literal">
        FLUSH
            LOGS
       </code>
      </a>
      SQL statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_flush-privileges">
      </a>
      <code class="literal">
       flush-privileges
      </code>
     </p>
     <p>
      Reload the grant tables (same as
      <code class="literal">
       reload
      </code>
      ).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_flush-status">
      </a>
      <code class="literal">
       flush-status
      </code>
     </p>
     <p>
      Clear status variables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_flush-tables">
      </a>
      <code class="literal">
       flush-tables
      </code>
     </p>
     <p>
      Flush all tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_kill">
      </a>
      <code class="literal">
       kill
       <em class="replaceable">
        <code>
         id
        </code>
       </em>
       ,
       <em class="replaceable">
        <code>
         id
        </code>
       </em>
       ,...
      </code>
     </p>
     <p>
      Kill server threads. If multiple thread ID values are given,
            there must be no spaces in the list.
     </p>
     <p>
      To kill threads belonging to other users, the connected user
            must have the
      <a class="link" href="privileges-provided.html#priv_connection-admin">
       <code class="literal">
        CONNECTION_ADMIN
       </code>
      </a>
      privilege
            (or the deprecated
      <a class="link" href="privileges-provided.html#priv_super">
       <code class="literal">
        SUPER
       </code>
      </a>
      privilege).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_password">
      </a>
      <code class="literal">
       password
       <em class="replaceable">
        <code>
         new_password
        </code>
       </em>
      </code>
     </p>
     <p>
      Set a new password. This changes the password to
      <em class="replaceable">
       <code>
        new_password
       </code>
      </em>
      for the account that
            you use with
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      for connecting to
            the server. Thus, the next time you invoke
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      (or any other client program)
            using the same account, you must specify the new password.
     </p>
     <div class="warning" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Warning
      </div>
      <p>
       Setting a password using
       <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
        <span class="command">
         <strong>
          mysqladmin
         </strong>
        </span>
       </a>
       should be considered
       <span class="emphasis">
        <em>
         insecure
        </em>
       </span>
       . On
              some systems, your password becomes visible to system
              status programs such as
       <span class="command">
        <strong>
         ps
        </strong>
       </span>
       that may be
              invoked by other users to display command lines. MySQL
              clients typically overwrite the command-line password
              argument with zeros during their initialization sequence.
              However, there is still a brief interval during which the
              value is visible. Also, on some systems this overwriting
              strategy is ineffective and the password remains visible
              to
       <span class="command">
        <strong>
         ps
        </strong>
       </span>
       . (SystemV Unix systems and
              perhaps others are subject to this problem.)
      </p>
     </div>
     <p>
      If the
      <em class="replaceable">
       <code>
        new_password
       </code>
      </em>
      value
            contains spaces or other characters that are special to your
            command interpreter, you need to enclose it within quotation
            marks. On Windows, be sure to use double quotation marks
            rather than single quotation marks; single quotation marks
            are not stripped from the password, but rather are
            interpreted as part of the password. For example:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa16468277"><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">mysqladmin password <span class="token atrule">"my new password"</span></code></pre>
     </div>
     <p>
      The new password can be omitted following the
      <code class="literal">
       password
      </code>
      command. In this case,
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      prompts for the password
            value, which enables you to avoid specifying the password on
            the command line. Omitting the password value should be done
            only if
      <code class="literal">
       password
      </code>
      is the final command on
            the
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      command line. Otherwise,
            the next argument is taken as the password.
     </p>
     <div class="caution" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Caution
      </div>
      <p>
       Do not use this command used if the server was started
              with the
       <a class="link" href="server-options.html#option_mysqld_skip-grant-tables">
        <code class="option">
         --skip-grant-tables
        </code>
       </a>
       option.
              No password change is applied. This is true even if you
              precede the
       <code class="literal">
        password
       </code>
       command with
       <code class="literal">
        flush-privileges
       </code>
       on the same command
              line to re-enable the grant tables because the flush
              operation occurs after you connect. However, you can use
       <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
        <span class="command">
         <strong>
          mysqladmin flush-privileges
         </strong>
        </span>
       </a>
       to
              re-enable the grant table and then use a separate
       <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
        <span class="command">
         <strong>
          mysqladmin password
         </strong>
        </span>
       </a>
       command to change
              the password.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_ping">
      </a>
      <code class="literal">
       ping
      </code>
     </p>
     <p>
      Check whether the server is available. The return status
            from
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      is 0 if the server is
            running, 1 if it is not. This is 0 even in case of an error
            such as
      <code class="literal">
       Access denied
      </code>
      , because this means
            that the server is running but refused the connection, which
            is different from the server not running.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_processlist">
      </a>
      <code class="literal">
       processlist
      </code>
     </p>
     <p>
      Show a list of active server threads. This is like the
            output of the
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW
            PROCESSLIST
       </code>
      </a>
      statement. If the
      <a class="link" href="mysqladmin.html#option_mysqladmin_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
      option is
            given, the output is like that of
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW FULL
            PROCESSLIST
       </code>
      </a>
      . (See
      <a class="xref" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       Section 15.7.7.31, “SHOW PROCESSLIST Statement”
      </a>
      .)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_reload">
      </a>
      <code class="literal">
       reload
      </code>
     </p>
     <p>
      Reload the grant tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_refresh">
      </a>
      <code class="literal">
       refresh
      </code>
     </p>
     <p>
      Flush all tables and close and open log files.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_shutdown">
      </a>
      <code class="literal">
       shutdown
      </code>
     </p>
     <p>
      Stop the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_start-replica">
      </a>
      <code class="literal">
       start-replica
      </code>
     </p>
     <p>
      Start replication on a replica server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_start-slave">
      </a>
      <code class="literal">
       start-slave
      </code>
     </p>
     <p>
      This is a deprecated alias for start-replica.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_status">
      </a>
      <code class="literal">
       status
      </code>
     </p>
     <p>
      Display a short server status message.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_stop-replica">
      </a>
      <code class="literal">
       stop-replica
      </code>
     </p>
     <p>
      Stop replication on a replica server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_stop-slave">
      </a>
      <code class="literal">
       stop-slave
      </code>
     </p>
     <p>
      This is a deprecated alias for stop-replica.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_variables">
      </a>
      <code class="literal">
       variables
      </code>
     </p>
     <p>
      Display the server system variables and their values.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="command_mysqladmin_version">
      </a>
      <code class="literal">
       version
      </code>
     </p>
     <p>
      Display version information from the server.
     </p>
    </li>
   </ul>
  </div>
  <p>
   All commands can be shortened to any unique prefix. For example:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa54888702"><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">mysqladmin</span> proc stat
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Id <span class="token punctuation">|</span> User  <span class="token punctuation">|</span> Host      <span class="token punctuation">|</span> db <span class="token punctuation">|</span> Command <span class="token punctuation">|</span> Time <span class="token punctuation">|</span> State <span class="token punctuation">|</span> Info             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> 51 <span class="token punctuation">|</span> jones <span class="token punctuation">|</span> localhost <span class="token punctuation">|</span>    <span class="token punctuation">|</span> Query   <span class="token punctuation">|</span> 0    <span class="token punctuation">|</span>       <span class="token punctuation">|</span> show processlist <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
Uptime<span class="token punctuation">:</span> 1473624  Threads<span class="token punctuation">:</span> 1  Questions<span class="token punctuation">:</span> 39487
Slow queries<span class="token punctuation">:</span> 0  Opens<span class="token punctuation">:</span> 541  Flush tables<span class="token punctuation">:</span> 1
Open tables<span class="token punctuation">:</span> 19  Queries per second avg<span class="token punctuation">:</span> 0<span class="token punctuation">.</span>0268</code></pre>
  </div>
  <a class="indexterm" name="idm46045316978928">
  </a>
  <p>
   The
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin status
     </strong>
    </span>
   </a>
   command result displays
        the following values:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316975024">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Uptime">
       <code class="literal">
        Uptime
       </code>
      </a>
     </p>
     <p>
      The number of seconds the MySQL server has been running.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316971440">
      </a>
      <code class="literal">
       Threads
      </code>
     </p>
     <p>
      The number of active threads (clients).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316968448">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Questions">
       <code class="literal">
        Questions
       </code>
      </a>
     </p>
     <p>
      The number of questions (queries) from clients since the
            server was started.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316964720">
      </a>
      <code class="literal">
       Slow queries
      </code>
     </p>
     <p>
      The number of queries that have taken more than
      <a class="link" href="server-system-variables.html#sysvar_long_query_time">
       <code class="literal">
        long_query_time
       </code>
      </a>
      seconds.
            See
      <a class="xref" href="slow-query-log.html" title="7.4.5 The Slow Query Log">
       Section 7.4.5, “The Slow Query Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316959664">
      </a>
      <code class="literal">
       Opens
      </code>
     </p>
     <p>
      The number of tables the server has opened.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316956672">
      </a>
      <a class="indexterm" name="idm46045316955600">
      </a>
      <code class="literal">
       Flush tables
      </code>
     </p>
     <p>
      The number of
      <code class="literal">
       flush-*
      </code>
      ,
      <code class="literal">
       refresh
      </code>
      , and
      <code class="literal">
       reload
      </code>
      commands the server has executed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045316950016">
      </a>
      <code class="literal">
       Open tables
      </code>
     </p>
     <p>
      The number of tables that currently are open.
     </p>
    </li>
   </ul>
  </div>
  <p>
   If you execute
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin shutdown
     </strong>
    </span>
   </a>
   when
        connecting to a local server using a Unix socket file,
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin
     </strong>
    </span>
   </a>
   waits until the server's process
        ID file has been removed, to ensure that the server has stopped
        properly.
  </p>
  <a class="indexterm" name="idm46045316944336">
  </a>
  <a class="indexterm" name="idm46045316943248">
  </a>
  <a class="indexterm" name="idm46045316941760">
  </a>
  <a class="indexterm" name="idm46045316939856">
  </a>
  <p>
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin
     </strong>
    </span>
   </a>
   supports the following options,
        which can be specified on the command line or in the
   <code class="literal">
    [mysqladmin]
   </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="idm46045316934464">
   </a>
   <p class="title">
    <b>
     Table 6.11 mysqladmin Options
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Command-line options available for mysqladmin.">
     <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="mysqladmin.html#option_mysqladmin_bind-address">
         --bind-address
        </a>
       </td>
       <td>
        Use specified network interface to connect to MySQL Server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_character-sets-dir">
         --character-sets-dir
        </a>
       </td>
       <td>
        Directory where character sets can be found
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_compress">
         --compress
        </a>
       </td>
       <td>
        Compress all information sent between client and server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_compression-algorithms">
         --compression-algorithms
        </a>
       </td>
       <td>
        Permitted compression algorithms for connections to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_connect-timeout">
         --connect-timeout
        </a>
       </td>
       <td>
        Number of seconds before connection timeout
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_count">
         --count
        </a>
       </td>
       <td>
        Number of iterations to make for repeated command execution
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_debug">
         --debug
        </a>
       </td>
       <td>
        Write debugging log
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_debug-check">
         --debug-check
        </a>
       </td>
       <td>
        Print debugging information when program exits
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_default-auth">
         --default-auth
        </a>
       </td>
       <td>
        Authentication plugin to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_default-character-set">
         --default-character-set
        </a>
       </td>
       <td>
        Specify default character set
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_defaults-file">
         --defaults-file
        </a>
       </td>
       <td>
        Read only named option file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_defaults-group-suffix">
         --defaults-group-suffix
        </a>
       </td>
       <td>
        Option group suffix value
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_enable-cleartext-plugin">
         --enable-cleartext-plugin
        </a>
       </td>
       <td>
        Enable cleartext authentication plugin
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_force">
         --force
        </a>
       </td>
       <td>
        Continue even if an SQL error occurs
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_help">
         --help
        </a>
       </td>
       <td>
        Display help message and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_host">
         --host
        </a>
       </td>
       <td>
        Host on which MySQL server is located
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_login-path">
         --login-path
        </a>
       </td>
       <td>
        Read login path options from .mylogin.cnf
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_no-beep">
         --no-beep
        </a>
       </td>
       <td>
        Do not beep when errors occur
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_no-defaults">
         --no-defaults
        </a>
       </td>
       <td>
        Read no option files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_password">
         --password
        </a>
       </td>
       <td>
        Password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_password1">
         --password1
        </a>
       </td>
       <td>
        First multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_password2">
         --password2
        </a>
       </td>
       <td>
        Second multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_password3">
         --password3
        </a>
       </td>
       <td>
        Third multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_pipe">
         --pipe
        </a>
       </td>
       <td>
        Connect to server using named pipe (Windows only)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_plugin-dir">
         --plugin-dir
        </a>
       </td>
       <td>
        Directory where plugins are installed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_port">
         --port
        </a>
       </td>
       <td>
        TCP/IP port number for connection
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_print-defaults">
         --print-defaults
        </a>
       </td>
       <td>
        Print default options
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_protocol">
         --protocol
        </a>
       </td>
       <td>
        Transport protocol to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_relative">
         --relative
        </a>
       </td>
       <td>
        Show the difference between the current and previous values when used with the --sleep option
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_show-warnings">
         --show-warnings
        </a>
       </td>
       <td>
        Show warnings after statement execution
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_shutdown-timeout">
         --shutdown-timeout
        </a>
       </td>
       <td>
        The maximum number of seconds to wait for server shutdown
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_silent">
         --silent
        </a>
       </td>
       <td>
        Silent mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_sleep">
         --sleep
        </a>
       </td>
       <td>
        Execute commands repeatedly, sleeping for delay seconds in between
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_socket">
         --socket
        </a>
       </td>
       <td>
        Unix socket file or Windows named pipe to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-ca
        </a>
       </td>
       <td>
        File that contains list of trusted SSL Certificate Authorities
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-capath
        </a>
       </td>
       <td>
        Directory that contains trusted SSL Certificate Authority certificate files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-cert
        </a>
       </td>
       <td>
        File that contains X.509 certificate
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-cipher
        </a>
       </td>
       <td>
        Permissible ciphers for connection encryption
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-crl
        </a>
       </td>
       <td>
        File that contains certificate revocation lists
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-crlpath
        </a>
       </td>
       <td>
        Directory that contains certificate revocation-list files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-key
        </a>
       </td>
       <td>
        File that contains X.509 key
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-mode
        </a>
       </td>
       <td>
        Desired security state of connection to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_ssl">
         --ssl-session-data
        </a>
       </td>
       <td>
        File that contains SSL session data
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_tls-ciphersuites">
         --tls-ciphersuites
        </a>
       </td>
       <td>
        Permissible TLSv1.3 ciphersuites for encrypted connections
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_tls-sni-servername">
         --tls-sni-servername
        </a>
       </td>
       <td>
        Server name supplied by the client
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_tls-version">
         --tls-version
        </a>
       </td>
       <td>
        Permissible TLS protocols for encrypted connections
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_user">
         --user
        </a>
       </td>
       <td>
        MySQL user name to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_verbose">
         --verbose
        </a>
       </td>
       <td>
        Verbose mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_version">
         --version
        </a>
       </td>
       <td>
        Display version information and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_vertical">
         --vertical
        </a>
       </td>
       <td>
        Print query output rows vertically (one line per column value)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_wait">
         --wait
        </a>
       </td>
       <td>
        If the connection cannot be established, wait and retry instead of aborting
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqladmin.html#option_mysqladmin_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_mysqladmin_help">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316756960">
     </a>
     <a class="indexterm" name="idm46045316755472">
     </a>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_bind-address">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316745504">
     </a>
     <a class="indexterm" name="idm46045316744016">
     </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_mysqladmin_character-sets-dir">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316729440">
     </a>
     <a class="indexterm" name="idm46045316727936">
     </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_mysqladmin_compress">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_compress">
       <code class="option">
        --compress
       </code>
      </a>
      ,
      <code class="option">
       -C
      </code>
     </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="idm46045316710640">
     </a>
     <a class="indexterm" name="idm46045316709152">
     </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_mysqladmin_compression-algorithms">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316687840">
     </a>
     <a class="indexterm" name="idm46045316686336">
     </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_mysqladmin_connect-timeout">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_connect-timeout">
       <code class="option">
        --connect-timeout=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-timeout=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           43200
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316668640">
     </a>
     <a class="indexterm" name="idm46045316667152">
     </a>
     <p>
      The maximum number of seconds before connection timeout. The
            default value is 43200 (12 hours).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_count">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_count">
       <code class="option">
        --count=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -c
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for count">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --count=#
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316656576">
     </a>
     <a class="indexterm" name="idm46045316655088">
     </a>
     <p>
      The number of iterations to make for repeated command
            execution if the
      <a class="link" href="mysqladmin.html#option_mysqladmin_sleep">
       <code class="option">
        --sleep
       </code>
      </a>
      option is given.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_debug">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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,/tmp/mysqladmin.trace
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316638688">
     </a>
     <a class="indexterm" name="idm46045316637200">
     </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,/tmp/mysqladmin.trace
      </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_mysqladmin_debug-check">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316618880">
     </a>
     <a class="indexterm" name="idm46045316617392">
     </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_mysqladmin_debug-info">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316601344">
     </a>
     <a class="indexterm" name="idm46045316599856">
     </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_mysqladmin_default-auth">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316585856">
     </a>
     <a class="indexterm" name="idm46045316584368">
     </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_mysqladmin_default-character-set">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316571664">
     </a>
     <a class="indexterm" name="idm46045316570160">
     </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_mysqladmin_defaults-extra-file">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316557024">
     </a>
     <a class="indexterm" name="idm46045316555520">
     </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_mysqladmin_defaults-file">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316541616">
     </a>
     <a class="indexterm" name="idm46045316540128">
     </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_mysqladmin_defaults-group-suffix">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316524160">
     </a>
     <a class="indexterm" name="idm46045316522656">
     </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="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      normally reads the
      <code class="literal">
       [client]
      </code>
      and
      <code class="literal">
       [mysqladmin]
      </code>
      groups. If this option is
            given as
      <a class="link" href="mysqladmin.html#option_mysqladmin_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=_other
       </code>
      </a>
      ,
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      also reads the
      <code class="literal">
       [client_other]
      </code>
      and
      <code class="literal">
       [mysqladmin_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_mysqladmin_enable-cleartext-plugin">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316500288">
     </a>
     <a class="indexterm" name="idm46045316498784">
     </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_mysqladmin_force">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316487392">
     </a>
     <a class="indexterm" name="idm46045316485904">
     </a>
     <p>
      Do not ask for confirmation for the
      <code class="literal">
       drop
       <em class="replaceable">
        <code>
         db_name
        </code>
       </em>
      </code>
      command. With
            multiple commands, continue even if an error occurs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_get-server-public-key">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316473120">
     </a>
     <a class="indexterm" name="idm46045316471616">
     </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="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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_mysqladmin_host">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316450560">
     </a>
     <a class="indexterm" name="idm46045316449072">
     </a>
     <p>
      Connect to the MySQL server on the given host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_login-path">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316437072">
     </a>
     <a class="indexterm" name="idm46045316435584">
     </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_mysqladmin_no-login-paths">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316421440">
     </a>
     <a class="indexterm" name="idm46045316419952">
     </a>
     <p>
      Skips reading options from the login path file.
     </p>
     <p>
      See
      <a class="link" href="mysqladmin.html#option_mysqladmin_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_mysqladmin_no-beep">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_no-beep">
       <code class="option">
        --no-beep
       </code>
      </a>
      ,
      <code class="option">
       -b
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-beep">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-beep
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316407232">
     </a>
     <a class="indexterm" name="idm46045316405744">
     </a>
     <p>
      Suppress the warning beep that is emitted by default for
            errors such as a failure to connect to the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_no-defaults">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316396048">
     </a>
     <a class="indexterm" name="idm46045316394560">
     </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="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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_mysqladmin_password">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316374320">
     </a>
     <a class="indexterm" name="idm46045316372832">
     </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="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      prompts for one. If given,
            there must be
      <span class="emphasis">
       <em>
        no space
       </em>
      </span>
      between
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      should not prompt for one, use
            the
      <a class="link" href="mysqladmin.html#option_mysqladmin_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_password1">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_password1">
       <code class="option">
        --password1[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045316360896">
     </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="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      prompts for one. If given, there
            must be
      <span class="emphasis">
       <em>
        no space
       </em>
      </span>
      between
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      should not prompt for one, use
            the
      <a class="link" href="mysqladmin.html#option_mysqladmin_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      option.
     </p>
     <p>
      <a class="link" href="mysqladmin.html#option_mysqladmin_password1">
       <code class="option">
        --password1
       </code>
      </a>
      and
      <a class="link" href="mysqladmin.html#option_mysqladmin_password">
       <code class="option">
        --password
       </code>
      </a>
      are
            synonymous, as are
      <a class="link" href="mysql-command-options.html#option_mysql_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      and
      <a class="link" href="mysql-command-options.html#option_mysql_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_password2">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_password2">
       <code class="option">
        --password2[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045316345408">
     </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="mysqladmin.html#option_mysqladmin_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_password3">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_password3">
       <code class="option">
        --password3[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045316340048">
     </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="mysqladmin.html#option_mysqladmin_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_pipe">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316327248">
     </a>
     <a class="indexterm" name="idm46045316325760">
     </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_mysqladmin_plugin-dir">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316311008">
     </a>
     <a class="indexterm" name="idm46045316309520">
     </a>
     <p>
      The directory in which to look for plugins. Specify this
            option if the
      <a class="link" href="mysqladmin.html#option_mysqladmin_default-auth">
       <code class="option">
        --default-auth
       </code>
      </a>
      option is
            used to specify an authentication plugin but
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </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_mysqladmin_port">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316291392">
     </a>
     <a class="indexterm" name="idm46045316289904">
     </a>
     <p>
      For TCP/IP connections, the port number to use.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_print-defaults">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316280240">
     </a>
     <a class="indexterm" name="idm46045316278752">
     </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_mysqladmin_protocol">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316257680">
     </a>
     <a class="indexterm" name="idm46045316256192">
     </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_mysqladmin_relative">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_relative">
       <code class="option">
        --relative
       </code>
      </a>
      ,
      <code class="option">
       -r
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for relative">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --relative
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316245184">
     </a>
     <a class="indexterm" name="idm46045316243696">
     </a>
     <p>
      Show the difference between the current and previous values
            when used with the
      <a class="link" href="mysqladmin.html#option_mysqladmin_sleep">
       <code class="option">
        --sleep
       </code>
      </a>
      option. This
            option works only with the
      <code class="literal">
       extended-status
      </code>
      command.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_server-public-key-path">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316229808">
     </a>
     <a class="indexterm" name="idm46045316228304">
     </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="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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_mysqladmin_shared-memory-base-name">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316206864">
     </a>
     <a class="indexterm" name="idm46045316205360">
     </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_mysqladmin_show-warnings">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_show-warnings">
       <code class="option">
        --show-warnings
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for show-warnings">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --show-warnings
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316193104">
     </a>
     <a class="indexterm" name="idm46045316191616">
     </a>
     <p>
      Show warnings resulting from execution of statements sent to
            the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_shutdown-timeout">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_shutdown-timeout">
       <code class="option">
        --shutdown-timeout=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for shutdown-timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --shutdown-timeout=seconds
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           3600
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316177104">
     </a>
     <a class="indexterm" name="idm46045316175616">
     </a>
     <p>
      The maximum number of seconds to wait for server shutdown.
            The default value is 3600 (1 hour).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_silent">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316165440">
     </a>
     <a class="indexterm" name="idm46045316163952">
     </a>
     <p>
      Exit silently if a connection to the server cannot be
            established.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_sleep">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_sleep">
       <code class="option">
        --sleep=
        <em class="replaceable">
         <code>
          delay
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -i
       <em class="replaceable">
        <code>
         delay
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sleep">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sleep=delay
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045316153392">
     </a>
     <a class="indexterm" name="idm46045316151904">
     </a>
     <p>
      Execute commands repeatedly, sleeping for
      <em class="replaceable">
       <code>
        delay
       </code>
      </em>
      seconds in between. The
      <a class="link" href="mysqladmin.html#option_mysqladmin_count">
       <code class="option">
        --count
       </code>
      </a>
      option determines
            the number of iterations. If
      <a class="link" href="mysqladmin.html#option_mysqladmin_count">
       <code class="option">
        --count
       </code>
      </a>
      is not given,
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      executes commands indefinitely
            until interrupted.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_socket">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316135440">
     </a>
     <a class="indexterm" name="idm46045316133952">
     </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_mysqladmin_ssl">
      </a>
      <code class="option">
       --ssl*
      </code>
     </p>
     <a class="indexterm" name="idm46045316126368">
     </a>
     <a class="indexterm" name="idm46045316124880">
     </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_mysqladmin_ssl-fips-mode">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316102736">
     </a>
     <a class="indexterm" name="idm46045316101248">
     </a>
     <p>
      Controls whether to enable FIPS mode on the client side. The
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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="mysqladmin.html#option_mysqladmin_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_mysqladmin_tls-ciphersuites">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316074288">
     </a>
     <a class="indexterm" name="idm46045316072800">
     </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_mysqladmin_tls-sni-servername">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316059808">
     </a>
     <a class="indexterm" name="idm46045316058304">
     </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_mysqladmin_tls-version">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316037424">
     </a>
     <a class="indexterm" name="idm46045316035936">
     </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_mysqladmin_user">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316022432">
     </a>
     <a class="indexterm" name="idm46045316020944">
     </a>
     <p>
      The user name of the MySQL account to use for connecting to
            the server.
     </p>
     <p>
      If you are using the
      <code class="literal">
       Rewriter
      </code>
      plugin,
            grant this user the
      <a class="link" href="privileges-provided.html#priv_skip-query-rewrite">
       <code class="literal">
        SKIP_QUERY_REWRITE
       </code>
      </a>
      privilege.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_verbose">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045316008320">
     </a>
     <a class="indexterm" name="idm46045316006832">
     </a>
     <p>
      Verbose mode. Print more information about what the program
            does.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_version">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045315996736">
     </a>
     <a class="indexterm" name="idm46045315995248">
     </a>
     <p>
      Display version information and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_vertical">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_vertical">
       <code class="option">
        --vertical
       </code>
      </a>
      ,
      <code class="option">
       -E
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for vertical">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --vertical
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315985184">
     </a>
     <a class="indexterm" name="idm46045315983696">
     </a>
     <p>
      Print output vertically. This is similar to
      <a class="link" href="mysqladmin.html#option_mysqladmin_relative">
       <code class="option">
        --relative
       </code>
      </a>
      , but prints
            output vertically.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_wait">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_wait">
       <code class="option">
        --wait[=
        <em class="replaceable">
         <code>
          count
         </code>
        </em>
        ]
       </code>
      </a>
      ,
      <code class="option">
       -w[
       <em class="replaceable">
        <code>
         count
        </code>
       </em>
       ]
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for wait">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --wait
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045315971840">
     </a>
     <a class="indexterm" name="idm46045315970352">
     </a>
     <p>
      If the connection cannot be established, wait and retry
            instead of aborting. If a
      <em class="replaceable">
       <code>
        count
       </code>
      </em>
      value is given, it indicates the number of times to retry.
            The default is one time.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqladmin_zstd-compression-level">
      </a>
      <a class="link" href="mysqladmin.html#option_mysqladmin_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="idm46045315957600">
     </a>
     <a class="indexterm" name="idm46045315956096">
     </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>
