<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-command-options">
      </a>
      6.5.1.1 mysql Client Options
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045320152032">
  </a>
  <a class="indexterm" name="idm46045320150960">
  </a>
  <a class="indexterm" name="idm46045320149472">
  </a>
  <a class="indexterm" name="idm46045320147568">
  </a>
  <p>
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   supports the following options, which
        can be specified on the command line or in the
   <code class="literal">
    [mysql]
   </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="idm46045320142176">
   </a>
   <p class="title">
    <b>
     Table 6.10 mysql Client Options
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Command-line options available for the mysql client.">
     <colgroup>
      <col style="width: 31%"/>
      <col style="width: 56%"/>
      <col style="width: 12%"/>
     </colgroup>
     <thead>
      <tr>
       <th scope="col">
        Option Name
       </th>
       <th scope="col">
        Description
       </th>
       <th scope="col">
        Introduced
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_auto-rehash">
         --auto-rehash
        </a>
       </th>
       <td>
        Enable automatic rehashing
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_auto-vertical-output">
         --auto-vertical-output
        </a>
       </th>
       <td>
        Enable automatic vertical result set display
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_batch">
         --batch
        </a>
       </th>
       <td>
        Do not use history file
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
         --binary-as-hex
        </a>
       </th>
       <td>
        Display binary values in hexadecimal notation
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_binary-mode">
         --binary-mode
        </a>
       </th>
       <td>
        Disable \r\n - to - \n translation and treatment of \0 as end-of-query
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_bind-address">
         --bind-address
        </a>
       </th>
       <td>
        Use specified network interface to connect to MySQL Server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_character-sets-dir">
         --character-sets-dir
        </a>
       </th>
       <td>
        Directory where character sets are installed
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_column-names">
         --column-names
        </a>
       </th>
       <td>
        Write column names in results
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_column-type-info">
         --column-type-info
        </a>
       </th>
       <td>
        Display result set metadata
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_comments">
         --comments
        </a>
       </th>
       <td>
        Whether to retain or strip comments in statements sent to the server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_compress">
         --compress
        </a>
       </th>
       <td>
        Compress all information sent between client and server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_compression-algorithms">
         --compression-algorithms
        </a>
       </th>
       <td>
        Permitted compression algorithms for connections to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_connect-expired-password">
         --connect-expired-password
        </a>
       </th>
       <td>
        Indicate to server that client can handle expired-password sandbox mode
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_connect-timeout">
         --connect-timeout
        </a>
       </th>
       <td>
        Number of seconds before connection timeout
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_database">
         --database
        </a>
       </th>
       <td>
        The database to use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_debug">
         --debug
        </a>
       </th>
       <td>
        Write debugging log; supported only if MySQL was built with debugging support
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_debug-check">
         --debug-check
        </a>
       </th>
       <td>
        Print debugging information when program exits
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_debug-info">
         --debug-info
        </a>
       </th>
       <td>
        Print debugging information, memory, and CPU statistics when program exits
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_default-auth">
         --default-auth
        </a>
       </th>
       <td>
        Authentication plugin to use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_default-character-set">
         --default-character-set
        </a>
       </th>
       <td>
        Specify default character set
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_defaults-extra-file">
         --defaults-extra-file
        </a>
       </th>
       <td>
        Read named option file in addition to usual option files
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_defaults-file">
         --defaults-file
        </a>
       </th>
       <td>
        Read only named option file
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_defaults-group-suffix">
         --defaults-group-suffix
        </a>
       </th>
       <td>
        Option group suffix value
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_delimiter">
         --delimiter
        </a>
       </th>
       <td>
        Set the statement delimiter
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
         --dns-srv-name
        </a>
       </th>
       <td>
        Use DNS SRV lookup for host information
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_enable-cleartext-plugin">
         --enable-cleartext-plugin
        </a>
       </th>
       <td>
        Enable cleartext authentication plugin
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_execute">
         --execute
        </a>
       </th>
       <td>
        Execute the statement and quit
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_force">
         --force
        </a>
       </th>
       <td>
        Continue even if an SQL error occurs
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_get-server-public-key">
         --get-server-public-key
        </a>
       </th>
       <td>
        Request RSA public key from server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_help">
         --help
        </a>
       </th>
       <td>
        Display help message and exit
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_histignore">
         --histignore
        </a>
       </th>
       <td>
        Patterns specifying which statements to ignore for logging
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_host">
         --host
        </a>
       </th>
       <td>
        Host on which MySQL server is located
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_html">
         --html
        </a>
       </th>
       <td>
        Produce HTML output
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ignore-spaces">
         --ignore-spaces
        </a>
       </th>
       <td>
        Ignore spaces after function names
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_init-command">
         --init-command
        </a>
       </th>
       <td>
        SQL statement to execute after connecting
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_init-command-add">
         --init-command-add
        </a>
       </th>
       <td>
        Add an additional SQL statement to execute after connecting or re-connecting to MySQL server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_line-numbers">
         --line-numbers
        </a>
       </th>
       <td>
        Write line numbers for errors
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
         --load-data-local-dir
        </a>
       </th>
       <td>
        Directory for files named in LOAD DATA LOCAL statements
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
         --local-infile
        </a>
       </th>
       <td>
        Enable or disable for LOCAL capability for LOAD DATA
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_login-path">
         --login-path
        </a>
       </th>
       <td>
        Read login path options from .mylogin.cnf
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_max-allowed-packet">
         --max-allowed-packet
        </a>
       </th>
       <td>
        Maximum packet length to send to or receive from server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_max-join-size">
         --max-join-size
        </a>
       </th>
       <td>
        The automatic limit for rows in a join when using --safe-updates
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_named-commands">
         --named-commands
        </a>
       </th>
       <td>
        Enable named mysql commands
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_net-buffer-length">
         --net-buffer-length
        </a>
       </th>
       <td>
        Buffer size for TCP/IP and socket communication
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_network-namespace">
         --network-namespace
        </a>
       </th>
       <td>
        Specify network namespace
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_no-auto-rehash">
         --no-auto-rehash
        </a>
       </th>
       <td>
        Disable automatic rehashing
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_no-beep">
         --no-beep
        </a>
       </th>
       <td>
        Do not beep when errors occur
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_no-defaults">
         --no-defaults
        </a>
       </th>
       <td>
        Read no option files
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_no-login-paths">
         --no-login-paths
        </a>
       </th>
       <td>
        Do not read login paths from the login path file
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_oci-config-file">
         --oci-config-file
        </a>
       </th>
       <td>
        Defines an alternate location for the Oracle Cloud Infrastructure CLI configuration file.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_one-database">
         --one-database
        </a>
       </th>
       <td>
        Ignore statements except those for the default database named on the command line
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_pager">
         --pager
        </a>
       </th>
       <td>
        Use the given command for paging query output
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_password">
         --password
        </a>
       </th>
       <td>
        Password to use when connecting to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_password1">
         --password1
        </a>
       </th>
       <td>
        First multifactor authentication password to use when connecting to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_password2">
         --password2
        </a>
       </th>
       <td>
        Second multifactor authentication password to use when connecting to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_password3">
         --password3
        </a>
       </th>
       <td>
        Third multifactor authentication password to use when connecting to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_pipe">
         --pipe
        </a>
       </th>
       <td>
        Connect to server using named pipe (Windows only)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_plugin-authentication-kerberos-client-mode">
         --plugin-authentication-kerberos-client-mode
        </a>
       </th>
       <td>
        Permit GSSAPI pluggable authentication through the MIT Kerberos library on Windows
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_plugin-authentication-webauthn-client-preserve-privacy">
         --plugin-authentication-webauthn-client-preserve-privacy
        </a>
       </th>
       <td>
        Permit user to choose a key to be used for assertion
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_plugin-dir">
         --plugin-dir
        </a>
       </th>
       <td>
        Directory where plugins are installed
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_port">
         --port
        </a>
       </th>
       <td>
        TCP/IP port number for connection
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_print-defaults">
         --print-defaults
        </a>
       </th>
       <td>
        Print default options
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_prompt">
         --prompt
        </a>
       </th>
       <td>
        Set the prompt to the specified format
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_protocol">
         --protocol
        </a>
       </th>
       <td>
        Transport protocol to use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_quick">
         --quick
        </a>
       </th>
       <td>
        Do not cache each query result
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_raw">
         --raw
        </a>
       </th>
       <td>
        Write column values without escape conversion
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_reconnect">
         --reconnect
        </a>
       </th>
       <td>
        If the connection to the server is lost, automatically try to reconnect
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_register-factor">
         --register-factor
        </a>
       </th>
       <td>
        Multifactor authentication factors for which registration must be done
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
         --safe-updates
        </a>
        ,
        <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
         --i-am-a-dummy
        </a>
       </th>
       <td>
        Allow only UPDATE and DELETE statements that specify key values
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_select-limit">
         --select-limit
        </a>
       </th>
       <td>
        The automatic limit for SELECT statements when using --safe-updates
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_server-public-key-path">
         --server-public-key-path
        </a>
       </th>
       <td>
        Path name to file containing RSA public key
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_shared-memory-base-name">
         --shared-memory-base-name
        </a>
       </th>
       <td>
        Shared-memory name for shared-memory connections (Windows only)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_show-warnings">
         --show-warnings
        </a>
       </th>
       <td>
        Show warnings after each statement if there are any
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_sigint-ignore">
         --sigint-ignore
        </a>
       </th>
       <td>
        Ignore SIGINT signals (typically the result of typing Control+C)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_silent">
         --silent
        </a>
       </th>
       <td>
        Silent mode
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_auto-rehash">
         --skip-auto-rehash
        </a>
       </th>
       <td>
        Disable automatic rehashing
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_skip-column-names">
         --skip-column-names
        </a>
       </th>
       <td>
        Do not write column names in results
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_skip-line-numbers">
         --skip-line-numbers
        </a>
       </th>
       <td>
        Skip line numbers for errors
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_named-commands">
         --skip-named-commands
        </a>
       </th>
       <td>
        Disable named mysql commands
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_pager">
         --skip-pager
        </a>
       </th>
       <td>
        Disable paging
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_reconnect">
         --skip-reconnect
        </a>
       </th>
       <td>
        Disable reconnecting
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_skip-system-command">
         --skip-system-command
        </a>
       </th>
       <td>
        Disable system (\!) command
       </td>
       <td>
        8.4.3
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_socket">
         --socket
        </a>
       </th>
       <td>
        Unix socket file or Windows named pipe to use
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-ca
        </a>
       </th>
       <td>
        File that contains list of trusted SSL Certificate Authorities
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-capath
        </a>
       </th>
       <td>
        Directory that contains trusted SSL Certificate Authority certificate files
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-cert
        </a>
       </th>
       <td>
        File that contains X.509 certificate
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-cipher
        </a>
       </th>
       <td>
        Permissible ciphers for connection encryption
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-crl
        </a>
       </th>
       <td>
        File that contains certificate revocation lists
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-crlpath
        </a>
       </th>
       <td>
        Directory that contains certificate revocation-list files
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl-fips-mode">
         --ssl-fips-mode
        </a>
       </th>
       <td>
        Whether to enable FIPS mode on client side
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-key
        </a>
       </th>
       <td>
        File that contains X.509 key
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-mode
        </a>
       </th>
       <td>
        Desired security state of connection to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-session-data
        </a>
       </th>
       <td>
        File that contains SSL session data
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_ssl">
         --ssl-session-data-continue-on-failed-reuse
        </a>
       </th>
       <td>
        Whether to establish connections if session reuse fails
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_syslog">
         --syslog
        </a>
       </th>
       <td>
        Log interactive statements to syslog
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_system-command">
         --system-command
        </a>
       </th>
       <td>
        Enable or disable system (\!) command
       </td>
       <td>
        8.4.3
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_table">
         --table
        </a>
       </th>
       <td>
        Display output in tabular format
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_tee">
         --tee
        </a>
       </th>
       <td>
        Append a copy of output to named file
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_telemetry_client">
         --telemetry_client
        </a>
       </th>
       <td>
        Enables the telemetry client.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_bsp_max_export_batch_size">
         --otel_bsp_max_export_batch_size
        </a>
       </th>
       <td>
        See variable OTEL_BSP_MAX_EXPORT_BATCH_SIZE.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_bsp_max_queue_size">
         --otel_bsp_max_queue_size
        </a>
       </th>
       <td>
        See variable OTEL_BSP_MAX_QUEUE_SIZE.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_bsp_schedule_delay">
         --otel_bsp_schedule_delay
        </a>
       </th>
       <td>
        See variable OTEL_BSP_SCHEDULE_DELAY.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_certificates">
         --otel_exporter_otlp_traces_certificates
        </a>
       </th>
       <td>
        Not in use at this time. Reserved for future development.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_client_certificates">
         --otel_exporter_otlp_traces_client_certificates
        </a>
       </th>
       <td>
        Not in use at this time. Reserved for future development.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_client_key">
         --otel_exporter_otlp_traces_client_key
        </a>
       </th>
       <td>
        Not in use at this time. Reserved for future development.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_compression">
         --otel_exporter_otlp_traces_compression
        </a>
       </th>
       <td>
        Compression type
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_endpoint">
         --otel_exporter_otlp_traces_endpoint
        </a>
       </th>
       <td>
        The trace export endpoint
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_headers">
         --otel_exporter_otlp_traces_headers
        </a>
       </th>
       <td>
        Key-value pairs to be used as headers associated with HTTP requests
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_protocol">
         --otel_exporter_otlp_traces_protocol
        </a>
       </th>
       <td>
        The OTLP transport protocol
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_exporter_otlp_traces_timeout">
         --otel_exporter_otlp_traces_timeout
        </a>
       </th>
       <td>
        Time OLTP exporter waits for each batch export
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel-help">
         --otel-help
        </a>
       </th>
       <td>
        When enabled, prints help about telemetry_client options.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_log_level">
         --otel_log_level
        </a>
       </th>
       <td>
        Controls which opentelemetry logs are printed in the server logs
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel_resource_attributes">
         --otel_resource_attributes
        </a>
       </th>
       <td>
        See corresponding OpenTelemetry variable OTEL_RESOURCE_ATTRIBUTES.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="telemetry-trace-configuration.html#option_mysql_telemetry_client.otel-trace">
         --otel-trace
        </a>
       </th>
       <td>
        This system variable controls whether telemetry traces are collected or not.
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_tls-ciphersuites">
         --tls-ciphersuites
        </a>
       </th>
       <td>
        Permissible TLSv1.3 ciphersuites for encrypted connections
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_tls-sni-servername">
         --tls-sni-servername
        </a>
       </th>
       <td>
        Server name supplied by the client
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_tls-version">
         --tls-version
        </a>
       </th>
       <td>
        Permissible TLS protocols for encrypted connections
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_unbuffered">
         --unbuffered
        </a>
       </th>
       <td>
        Flush the buffer after each query
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_user">
         --user
        </a>
       </th>
       <td>
        MySQL user name to use when connecting to server
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_verbose">
         --verbose
        </a>
       </th>
       <td>
        Verbose mode
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_version">
         --version
        </a>
       </th>
       <td>
        Display version information and exit
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_vertical">
         --vertical
        </a>
       </th>
       <td>
        Print query output rows vertically (one line per column value)
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_wait">
         --wait
        </a>
       </th>
       <td>
        If the connection cannot be established, wait and retry instead of aborting
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_xml">
         --xml
        </a>
       </th>
       <td>
        Produce XML output
       </td>
       <td>
       </td>
      </tr>
      <tr>
       <th scope="row">
        <a class="link" href="mysql-command-options.html#option_mysql_zstd-compression-level">
         --zstd-compression-level
        </a>
       </th>
       <td>
        Compression level for connections to server that use zstd compression
       </td>
       <td>
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th scope="col" style="width: 318.25px;">
        Option Name
       </th>
       <th scope="col" style="width: 332.672px;">
        Description
       </th>
       <th scope="col" style="width: 87.0781px;">
        Introduced
       </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_mysql_help">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319662432">
     </a>
     <a class="indexterm" name="idm46045319660944">
     </a>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_auto-rehash">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_auto-rehash">
       <code class="option">
        --auto-rehash
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-rehash">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-rehash
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Disabled by
         </th>
         <td>
          <code class="literal">
           skip-auto-rehash
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319648832">
     </a>
     <a class="indexterm" name="idm46045319647344">
     </a>
     <p>
      Enable automatic rehashing. This option is on by default,
            which enables database, table, and column name completion.
            Use
      <a class="link" href="mysql-command-options.html#option_mysql_auto-rehash">
       <code class="option">
        --disable-auto-rehash
       </code>
      </a>
      to disable rehashing. That causes
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      to start faster, but you must issue the
      <code class="literal">
       rehash
      </code>
      command or its
      <code class="literal">
       \#
      </code>
      shortcut if you want to use name
            completion.
     </p>
     <p>
      To complete a name, enter the first part and press Tab. If
            the name is unambiguous,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      completes
            it. Otherwise, you can press Tab again to see the possible
            names that begin with what you have typed so far. Completion
            does not occur if there is no default database.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       This feature requires a MySQL client that is compiled with
              the
       <span class="bold">
        <strong>
         readline
        </strong>
       </span>
       library.
              Typically, the
       <span class="bold">
        <strong>
         readline
        </strong>
       </span>
       library is not available on Windows.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_auto-vertical-output">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_auto-vertical-output">
       <code class="option">
        --auto-vertical-output
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-vertical-output">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-vertical-output
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319629456">
     </a>
     <a class="indexterm" name="idm46045319627952">
     </a>
     <p>
      Cause result sets to be displayed vertically if they are too
            wide for the current window, and using normal tabular format
            otherwise. (This applies to statements terminated by
      <code class="literal">
       ;
      </code>
      or
      <code class="literal">
       \G
      </code>
      .)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_batch">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_batch">
       <code class="option">
        --batch
       </code>
      </a>
      ,
      <code class="option">
       -B
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for batch">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --batch
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319616448">
     </a>
     <a class="indexterm" name="idm46045319614960">
     </a>
     <p>
      Print results using tab as the column separator, with each
            row on a new line. With this option,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      does not use the history file.
     </p>
     <p>
      Batch mode results in nontabular output format and escaping
            of special characters. Escaping may be disabled by using raw
            mode; see the description for the
      <a class="link" href="mysql-command-options.html#option_mysql_raw">
       <code class="option">
        --raw
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_binary-as-hex">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
       <code class="option">
        --binary-as-hex
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for binary-as-hex">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --binary-as-hex
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE in noninteractive mode
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319597888">
     </a>
     <a class="indexterm" name="idm46045319596400">
     </a>
     <p>
      When this option is 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>
      displays
            binary data using hexadecimal notation
            (
      <code class="literal">
       0x
       <em class="replaceable">
        <code>
         value
        </code>
       </em>
      </code>
      ).
            This occurs whether the overall output display format is
            tabular, vertical, HTML, or XML.
     </p>
     <p>
      <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
       <code class="option">
        --binary-as-hex
       </code>
      </a>
      when enabled
            affects display of all binary strings, including those
            returned by functions such as
      <a class="link" href="string-functions.html#function_char">
       <code class="literal">
        CHAR()
       </code>
      </a>
      and
      <a class="link" href="string-functions.html#function_unhex">
       <code class="literal">
        UNHEX()
       </code>
      </a>
      . The following
            example demonstrates this using the ASCII code for
      <code class="literal">
       A
      </code>
      (65 decimal, 41 hexadecimal):
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
          <code class="option">
           --binary-as-hex
          </code>
         </a>
         disabled:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa71423711"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">0x41</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token function">UNHEX</span><span class="token punctuation">(</span><span class="token string">'41'</span><span class="token punctuation">)</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> CHAR(0x41) <span class="token punctuation">|</span> UNHEX('41') <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>
<span class="token output"><span class="token punctuation">|</span> A          <span class="token punctuation">|</span> A           <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></code></pre>
        </div>
       </li>
       <li class="listitem">
        <p>
         <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
          <code class="option">
           --binary-as-hex
          </code>
         </a>
         enabled:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa919940"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">0x41</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token function">UNHEX</span><span class="token punctuation">(</span><span class="token string">'41'</span><span class="token punctuation">)</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> CHAR(0x41)             <span class="token punctuation">|</span> UNHEX('41')              <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>
<span class="token output"><span class="token punctuation">|</span> 0x41                   <span class="token punctuation">|</span> 0x41                     <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></code></pre>
        </div>
       </li>
      </ul>
     </div>
     <p>
      To write a binary string expression so that it displays as a
            character string regardless of whether
      <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
       <code class="option">
        --binary-as-hex
       </code>
      </a>
      is enabled,
            use these techniques:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         The
         <a class="link" href="string-functions.html#function_char">
          <code class="literal">
           CHAR()
          </code>
         </a>
         function has a
         <code class="literal">
          USING
          <em class="replaceable">
           <code>
            charset
           </code>
          </em>
         </code>
         clause:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa50743476"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">0x41</span> <span class="token keyword">USING</span> utf8mb4<span class="token punctuation">)</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> CHAR(0x41 USING utf8mb4) <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>
<span class="token output"><span class="token punctuation">|</span> A                        <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></code></pre>
        </div>
       </li>
       <li class="listitem">
        <p>
         More generally, use
         <a class="link" href="cast-functions.html#function_convert">
          <code class="literal">
           CONVERT()
          </code>
         </a>
         to convert an
                expression to a given character set:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa31394599"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token function">CONVERT</span><span class="token punctuation">(</span><span class="token function">UNHEX</span><span class="token punctuation">(</span><span class="token string">'41'</span><span class="token punctuation">)</span> <span class="token keyword">USING</span> utf8mb4<span class="token punctuation">)</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> CONVERT(UNHEX('41') USING utf8mb4) <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>
<span class="token output"><span class="token punctuation">|</span> A                                  <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></code></pre>
        </div>
       </li>
      </ul>
     </div>
     <p>
      When
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      operates in interactive mode,
            this option is enabled by default. In addition, output from
            the
      <code class="literal">
       status
      </code>
      (or
      <code class="literal">
       \s
      </code>
      )
            command includes this line when the option is enabled
            implicitly or explicitly:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-none"><div class="docs-select-all right" id="sa99496713"><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-none">Binary data as: Hexadecimal</code></pre>
     </div>
     <p>
      To disable hexadecimal notation, use
      <a class="link" href="mysql-command-options.html#option_mysql_binary-as-hex">
       <code class="option">
        --skip-binary-as-hex
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_binary-mode">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_binary-mode">
       <code class="option">
        --binary-mode
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for binary-mode">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --binary-mode
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319555248">
     </a>
     <a class="indexterm" name="idm46045319553760">
     </a>
     <p>
      This option helps when processing
      <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
       <span class="command">
        <strong>
         mysqlbinlog
        </strong>
       </span>
      </a>
      output that may contain
      <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
       <code class="literal">
        BLOB
       </code>
      </a>
      values. By default,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      translates
      <code class="literal">
       \r\n
      </code>
      in statement strings to
      <code class="literal">
       \n
      </code>
      and interprets
      <code class="literal">
       \0
      </code>
      as the statement terminator.
      <a class="link" href="mysql-command-options.html#option_mysql_binary-mode">
       <code class="option">
        --binary-mode
       </code>
      </a>
      disables both
            features. It also disables all
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      commands except
      <code class="literal">
       charset
      </code>
      and
      <code class="literal">
       delimiter
      </code>
      in noninteractive mode (for
            input piped to
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      or loaded using the
      <code class="literal">
       source
      </code>
      command).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_bind-address">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319532160">
     </a>
     <a class="indexterm" name="idm46045319530672">
     </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_mysql_character-sets-dir">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_character-sets-dir">
       <code class="option">
        --character-sets-dir=
        <em class="replaceable">
         <code>
          dir_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for character-sets-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --character-sets-dir=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319518544">
     </a>
     <a class="indexterm" name="idm46045319517040">
     </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_mysql_column-names">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_column-names">
       <code class="option">
        --column-names
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for column-names">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --column-names
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319506544">
     </a>
     <a class="indexterm" name="idm46045319505056">
     </a>
     <p>
      Write column names in results.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_column-type-info">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_column-type-info">
       <code class="option">
        --column-type-info
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for column-type-info">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --column-type-info
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319495408">
     </a>
     <a class="indexterm" name="idm46045319493920">
     </a>
     <p>
      Display result set metadata. This information corresponds to
            the contents of C API
      <code class="literal">
       MYSQL_FIELD
      </code>
      data
            structures. See
      <a class="ulink" href="/doc/c-api/8.4/en/c-api-data-structures.html" target="_top">
       C API Basic Data Structures
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_comments">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_comments">
       <code class="option">
        --comments
       </code>
      </a>
      ,
      <code class="option">
       -c
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for comments">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --comments
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           TRUE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319477856">
     </a>
     <a class="indexterm" name="idm46045319476368">
     </a>
     <p>
      Whether to preserve or strip comments in statements sent to
            the server. The default is to preserve them; to strip them,
            start
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      with
      <code class="option">
       --skip-comments
      </code>
      .
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       The
       <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
        <span class="command">
         <strong>
          mysql
         </strong>
        </span>
       </a>
       client always passes
              optimizer hints to the server, regardless of whether this
              option is given.
      </p>
      <p>
       Comment stripping is deprecated. Expect this feature and
              the options to control it to be removed in a future MySQL
              release.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_compress">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319455440">
     </a>
     <a class="indexterm" name="idm46045319453952">
     </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_mysql_compression-algorithms">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319432720">
     </a>
     <a class="indexterm" name="idm46045319431216">
     </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_mysql_connect-expired-password">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_connect-expired-password">
       <code class="option">
        --connect-expired-password
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-expired-password">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-expired-password
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319418208">
     </a>
     <a class="indexterm" name="idm46045319416704">
     </a>
     <p>
      Indicate to the server that the client can handle sandbox
            mode if the account used to connect has an expired password.
            This can be useful for noninteractive invocations of
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      because normally the server
            disconnects noninteractive clients that attempt to connect
            using an account with an expired password. (See
      <a class="xref" href="expired-password-handling.html" title="8.2.16 Server Handling of Expired Passwords">
       Section 8.2.16, “Server Handling of Expired Passwords”
      </a>
      .)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_connect-timeout">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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">
           0
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319399888">
     </a>
     <a class="indexterm" name="idm46045319398400">
     </a>
     <p>
      The number of seconds before connection timeout. (Default
            value is
      <code class="literal">
       0
      </code>
      .)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_database">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_database">
       <code class="option">
        --database=
        <em class="replaceable">
         <code>
          db_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -D
       <em class="replaceable">
        <code>
         db_name
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for database">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --database=dbname
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319385056">
     </a>
     <a class="indexterm" name="idm46045319383568">
     </a>
     <p>
      The database to use. This is useful primarily in an option
            file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_debug">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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/mysql.trace
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319368176">
     </a>
     <a class="indexterm" name="idm46045319366688">
     </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/mysql.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_mysql_debug-check">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319348400">
     </a>
     <a class="indexterm" name="idm46045319346912">
     </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_mysql_debug-info">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_debug-info">
       <code class="option">
        --debug-info
       </code>
      </a>
      ,
      <code class="option">
       -T
      </code>
     </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="idm46045319330448">
     </a>
     <a class="indexterm" name="idm46045319328960">
     </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_mysql_default-auth">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319314960">
     </a>
     <a class="indexterm" name="idm46045319313472">
     </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_mysql_default-character-set">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319300704">
     </a>
     <a class="indexterm" name="idm46045319299200">
     </a>
     <p>
      Use
      <em class="replaceable">
       <code>
        charset_name
       </code>
      </em>
      as the default
            character set for the client and connection.
     </p>
     <p>
      This option can be useful if the operating system uses one
            character set and the
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      client by
            default uses another. In this case, output may be formatted
            incorrectly. You can usually fix such issues by using this
            option to force the client to use the system character set
            instead.
     </p>
     <p>
      For more information, see
      <a class="xref" href="charset-connection.html" title="12.4 Connection Character Sets and Collations">
       Section 12.4, “Connection Character Sets and Collations”
      </a>
      , and
      <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_mysql_defaults-extra-file">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319282816">
     </a>
     <a class="indexterm" name="idm46045319281312">
     </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_mysql_defaults-file">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319267408">
     </a>
     <a class="indexterm" name="idm46045319265920">
     </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_mysql_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319249952">
     </a>
     <a class="indexterm" name="idm46045319248448">
     </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="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      normally reads the
      <code class="literal">
       [client]
      </code>
      and
      <code class="literal">
       [mysql]
      </code>
      groups. If this option is given as
      <a class="link" href="mysql-command-options.html#option_mysql_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=_other
       </code>
      </a>
      ,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      also reads the
      <code class="literal">
       [client_other]
      </code>
      and
      <code class="literal">
       [mysql_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_mysql_delimiter">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_delimiter">
       <code class="option">
        --delimiter=
        <em class="replaceable">
         <code>
          str
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for delimiter">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --delimiter=str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           ;
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319226016">
     </a>
     <a class="indexterm" name="idm46045319224528">
     </a>
     <p>
      Set the statement delimiter. The default is the semicolon
            character (
      <code class="literal">
       ;
      </code>
      ).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_disable-named-commands">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_disable-named-commands">
       <code class="option">
        --disable-named-commands
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045319219472">
     </a>
     <a class="indexterm" name="idm46045319217984">
     </a>
     <p>
      Disable named commands. Use the
      <code class="literal">
       \*
      </code>
      form
            only, or use named commands only at the beginning of a line
            ending with a semicolon (
      <code class="literal">
       ;
      </code>
      ).
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      starts with this option
      <span class="emphasis">
       <em>
        enabled
       </em>
      </span>
      by default. However, even with
            this option, long-format commands still work from the first
            line. See
      <a class="xref" href="mysql-commands.html" title="6.5.1.2 mysql Client Commands">
       Section 6.5.1.2, “mysql Client Commands”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_dns-srv-name">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for dns-srv-name">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --dns-srv-name=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319202000">
     </a>
     <a class="indexterm" name="idm46045319200512">
     </a>
     <a class="indexterm" name="idm46045319199024">
     </a>
     <p>
      Specifies the name of a DNS SRV record that determines the
            candidate hosts to use for establishing a connection to a
            MySQL server. For information about DNS SRV support in
            MySQL, see
      <a class="xref" href="connecting-using-dns-srv.html" title="6.2.6 Connecting to the Server Using DNS SRV Records">
       Section 6.2.6, “Connecting to the Server Using DNS SRV Records”
      </a>
      .
     </p>
     <p>
      Suppose that DNS is configured with this SRV information for
            the
      <code class="literal">
       example.com
      </code>
      domain:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-simple"><div class="docs-select-all right" id="sa51594832"><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-simple">Name                     TTL   Class   Priority Weight Port Target
_mysql<span class="token punctuation">.</span>_tcp<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com<span class="token punctuation">.</span> 86400 IN SRV  0        5      3306 host1<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com
_mysql<span class="token punctuation">.</span>_tcp<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com<span class="token punctuation">.</span> 86400 IN SRV  0        10     3306 host2<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com
_mysql<span class="token punctuation">.</span>_tcp<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com<span class="token punctuation">.</span> 86400 IN SRV  10       5      3306 host3<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com
_mysql<span class="token punctuation">.</span>_tcp<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com<span class="token punctuation">.</span> 86400 IN SRV  20       5      3306 host4<span class="token punctuation">.</span>example<span class="token punctuation">.</span>com</code></pre>
     </div>
     <p>
      To use that DNS SRV record, invoke
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      like this:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa44568528"><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">mysql <span class="token constant">--dns-srv-name</span><span class="token attr-value"><span class="token punctuation">=</span>_mysql._tcp.example.com</span></code></pre>
     </div>
     <p>
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      then attempts a connection to each
            server in the group until a successful connection is
            established. A failure to connect occurs only if a
            connection cannot be established to any of the servers. The
            priority and weight values in the DNS SRV record determine
            the order in which servers should be tried.
     </p>
     <p>
      When invoked with
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      ,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      attempts to establish TCP
            connections only.
     </p>
     <p>
      The
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      option
            takes precedence over the
      <a class="link" href="mysql-command-options.html#option_mysql_host">
       <code class="option">
        --host
       </code>
      </a>
      option if both are
            given.
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      causes
            connection establishment to use the
      <a class="ulink" href="/doc/c-api/8.4/en/mysql-real-connect-dns-srv.html" target="_top">
       <code class="literal">
        mysql_real_connect_dns_srv()
       </code>
      </a>
      C API function rather than
      <a class="ulink" href="/doc/c-api/8.4/en/mysql-real-connect.html" target="_top">
       <code class="literal">
        mysql_real_connect()
       </code>
      </a>
      .
            However, if the
      <code class="literal">
       connect
      </code>
      command is
            subsequently used at runtime and specifies a host name
            argument, that host name takes precedence over any
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      option given at
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      startup to specify a DNS SRV
            record.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_enable-cleartext-plugin">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319165632">
     </a>
     <a class="indexterm" name="idm46045319164128">
     </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_mysql_execute">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_execute">
       <code class="option">
        --execute=
        <em class="replaceable">
         <code>
          statement
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -e
       <em class="replaceable">
        <code>
         statement
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for execute">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --execute=statement
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319149984">
     </a>
     <a class="indexterm" name="idm46045319148496">
     </a>
     <p>
      Execute the statement and quit. The default output format is
            like that produced with
      <a class="link" href="mysql-command-options.html#option_mysql_batch">
       <code class="option">
        --batch
       </code>
      </a>
      . See
      <a class="xref" href="command-line-options.html" title="6.2.2.1 Using Options on the Command Line">
       Section 6.2.2.1, “Using Options on the Command Line”
      </a>
      , for some examples.
            With this option,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      does not use the
            history file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_force">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319135488">
     </a>
     <a class="indexterm" name="idm46045319134000">
     </a>
     <p>
      Continue even if an SQL error occurs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_get-server-public-key">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319122288">
     </a>
     <a class="indexterm" name="idm46045319120784">
     </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="mysql-command-options.html#option_mysql_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="mysql-command-options.html#option_mysql_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_mysql_histignore">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_histignore">
       <code class="option">
        --histignore
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for histignore">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --histignore=pattern_list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319103168">
     </a>
     <a class="indexterm" name="idm46045319101680">
     </a>
     <p>
      A list of one or more colon-separated patterns specifying
            statements to ignore for logging purposes. These patterns
            are added to the default pattern list
            (
      <code class="literal">
       "*IDENTIFIED*:*PASSWORD*"
      </code>
      ). The value
            specified for this option affects logging of statements
            written to the history file, and to
      <code class="literal">
       syslog
      </code>
      if the
      <a class="link" href="mysql-command-options.html#option_mysql_syslog">
       <code class="option">
        --syslog
       </code>
      </a>
      option is given. For
            more information, see
      <a class="xref" href="mysql-logging.html" title="6.5.1.3 mysql Client Logging">
       Section 6.5.1.3, “mysql Client Logging”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_host">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045319083200">
     </a>
     <a class="indexterm" name="idm46045319081712">
     </a>
     <p>
      Connect to the MySQL server on the given host.
     </p>
     <p>
      The
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      option
            takes precedence over the
      <a class="link" href="mysql-command-options.html#option_mysql_host">
       <code class="option">
        --host
       </code>
      </a>
      option if both are
            given.
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      causes
            connection establishment to use the
      <a class="ulink" href="/doc/c-api/8.4/en/mysql-real-connect-dns-srv.html" target="_top">
       <code class="literal">
        mysql_real_connect_dns_srv()
       </code>
      </a>
      C API function rather than
      <a class="ulink" href="/doc/c-api/8.4/en/mysql-real-connect.html" target="_top">
       <code class="literal">
        mysql_real_connect()
       </code>
      </a>
      .
            However, if the
      <code class="literal">
       connect
      </code>
      command is
            subsequently used at runtime and specifies a host name
            argument, that host name takes precedence over any
      <a class="link" href="mysql-command-options.html#option_mysql_dns-srv-name">
       <code class="option">
        --dns-srv-name
       </code>
      </a>
      option given at
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      startup to specify a DNS SRV
            record.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_html">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_html">
       <code class="option">
        --html
       </code>
      </a>
      ,
      <code class="option">
       -H
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for html">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --html
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319062672">
     </a>
     <a class="indexterm" name="idm46045319061184">
     </a>
     <p>
      Produce HTML output.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_ignore-spaces">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_ignore-spaces">
       <code class="option">
        --ignore-spaces
       </code>
      </a>
      ,
      <code class="option">
       -i
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ignore-spaces">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ignore-spaces
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319051072">
     </a>
     <a class="indexterm" name="idm46045319049584">
     </a>
     <p>
      Ignore spaces after function names. The effect of this is
            described in the discussion for the
      <a class="link" href="sql-mode.html#sqlmode_ignore_space">
       <code class="literal">
        IGNORE_SPACE
       </code>
      </a>
      SQL mode (see
      <a class="xref" href="sql-mode.html" title="7.1.11 Server SQL Modes">
       Section 7.1.11, “Server SQL Modes”
      </a>
      ).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_init-command">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_init-command">
       <code class="option">
        --init-command=str
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for init-command">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --init-command=str
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319037808">
     </a>
     <a class="indexterm" name="idm46045319036320">
     </a>
     <p>
      Single SQL statement to execute after connecting to the
            server. If auto-reconnect is enabled, the statement is
            executed again after reconnection occurs. The definition
            resets existing statements defined by it or
      <a class="link" href="mysql-command-options.html#option_mysql_init-command-add">
       <code class="option">
        init-command-add
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_init-command-add">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_init-command-add">
       <code class="option">
        --init-command-add=str
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for init-command-add">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --init-command-add=str
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319025456">
     </a>
     <a class="indexterm" name="idm46045319023968">
     </a>
     <p>
      Add an additional SQL statement to execute after connecting
            or reconnecting to the MySQL server. It's usable without
      <a class="link" href="mysql-command-options.html#option_mysql_init-command">
       <code class="option">
        --init-command
       </code>
      </a>
      but has no
            effect if used before it because
      <a class="link" href="mysql-command-options.html#option_mysql_init-command">
       <code class="option">
        init-command
       </code>
      </a>
      resets the list
            of commands to call.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_line-numbers">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_line-numbers">
       <code class="option">
        --line-numbers
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for line-numbers">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --line-numbers
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Disabled by
         </th>
         <td>
          <code class="literal">
           skip-line-numbers
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045319009680">
     </a>
     <a class="indexterm" name="idm46045319008192">
     </a>
     <p>
      Write line numbers for errors. Disable this with
      <a class="link" href="mysql-command-options.html#option_mysql_skip-line-numbers">
       <code class="option">
        --skip-line-numbers
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_load-data-local-dir">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
       <code class="option">
        --load-data-local-dir=
        <em class="replaceable">
         <code>
          dir_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for load-data-local-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --load-data-local-dir=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           empty string
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318992720">
     </a>
     <a class="indexterm" name="idm46045318991216">
     </a>
     <p>
      This option affects the client-side
      <code class="literal">
       LOCAL
      </code>
      capability for
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD DATA
       </code>
      </a>
      operations. It specifies the directory in which files named
            in
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD DATA
            LOCAL
       </code>
      </a>
      statements must be located. The effect of
      <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
       <code class="option">
        --load-data-local-dir
       </code>
      </a>
      depends
            on whether
      <code class="literal">
       LOCAL
      </code>
      data loading is enabled
            or disabled:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         If
         <code class="literal">
          LOCAL
         </code>
         data loading is enabled,
                either by default in the MySQL client library or by
                specifying
         <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
          <code class="option">
           --local-infile[=1]
          </code>
         </a>
         , the
         <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
          <code class="option">
           --load-data-local-dir
          </code>
         </a>
         option is ignored.
        </p>
       </li>
       <li class="listitem">
        <p>
         If
         <code class="literal">
          LOCAL
         </code>
         data loading is disabled,
                either by default in the MySQL client library or by
                specifying
         <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
          <code class="option">
           --local-infile=0
          </code>
         </a>
         , the
         <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
          <code class="option">
           --load-data-local-dir
          </code>
         </a>
         option applies.
        </p>
       </li>
      </ul>
     </div>
     <p>
      When
      <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
       <code class="option">
        --load-data-local-dir
       </code>
      </a>
      applies, the option value designates the directory in which
            local data files must be located. Comparison of the
            directory path name and the path name of files to be loaded
            is case-sensitive regardless of the case sensitivity of the
            underlying file system. If the option value is the empty
            string, it names no directory, with the result that no files
            are permitted for local data loading.
     </p>
     <p>
      For example, to explicitly disable local data loading except
            for files located in the
      <code class="filename">
       /my/local/data
      </code>
      directory, invoke
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      like this:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa67815738"><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">mysql <span class="token constant">--local-infile</span><span class="token attr-value"><span class="token punctuation">=</span>0</span> <span class="token constant">--load-data-local-dir</span><span class="token attr-value"><span class="token punctuation">=</span>/my/local/data</span></code></pre>
     </div>
     <p>
      When both
      <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
       <code class="option">
        --local-infile
       </code>
      </a>
      and
      <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
       <code class="option">
        --load-data-local-dir
       </code>
      </a>
      are
            given, the order in which they are given does not matter.
     </p>
     <p>
      Successful use of
      <code class="literal">
       LOCAL
      </code>
      load operations
            within
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      also requires that the
            server permits local loading; see
      <a class="xref" href="load-data-local-security.html" title="8.1.6 Security Considerations for LOAD DATA LOCAL">
       Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_local-infile">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
       <code class="option">
        --local-infile[={0|1}]
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for local-infile">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --local-infile[={0|1}]
          </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="idm46045318953280">
     </a>
     <a class="indexterm" name="idm46045318951792">
     </a>
     <p>
      By default,
      <code class="literal">
       LOCAL
      </code>
      capability for
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD DATA
       </code>
      </a>
      is determined by
            the default compiled into the MySQL client library. To
            enable or disable
      <code class="literal">
       LOCAL
      </code>
      data loading
            explicitly, use the
      <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
       <code class="option">
        --local-infile
       </code>
      </a>
      option. When
            given with no value, the option enables
      <code class="literal">
       LOCAL
      </code>
      data loading. When given as
      <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
       <code class="option">
        --local-infile=0
       </code>
      </a>
      or
      <a class="link" href="mysql-command-options.html#option_mysql_local-infile">
       <code class="option">
        --local-infile=1
       </code>
      </a>
      , the option
            disables or enables
      <code class="literal">
       LOCAL
      </code>
      data loading.
     </p>
     <p>
      If
      <code class="literal">
       LOCAL
      </code>
      capability is disabled, the
      <a class="link" href="mysql-command-options.html#option_mysql_load-data-local-dir">
       <code class="option">
        --load-data-local-dir
       </code>
      </a>
      option
            can be used to permit restricted local loading of files
            located in a designated directory.
     </p>
     <p>
      Successful use of
      <code class="literal">
       LOCAL
      </code>
      load operations
            within
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      also requires that the
            server permits local loading; see
      <a class="xref" href="load-data-local-security.html" title="8.1.6 Security Considerations for LOAD DATA LOCAL">
       Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_login-path">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318927088">
     </a>
     <a class="indexterm" name="idm46045318925600">
     </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_mysql_no-login-paths">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318911456">
     </a>
     <a class="indexterm" name="idm46045318909968">
     </a>
     <p>
      Skips reading options from the login path file.
     </p>
     <p>
      See
      <a class="link" href="mysql-command-options.html#option_mysql_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
      for related
            information.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_max-allowed-packet">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_max-allowed-packet">
       <code class="option">
        --max-allowed-packet=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for max-allowed-packet">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --max-allowed-packet=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           16777216
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318892928">
     </a>
     <a class="indexterm" name="idm46045318891424">
     </a>
     <p>
      The maximum size of the buffer for client/server
            communication. The default is 16MB, the maximum is 1GB.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_max-join-size">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_max-join-size">
       <code class="option">
        --max-join-size=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for max-join-size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --max-join-size=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1000000
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318876880">
     </a>
     <a class="indexterm" name="idm46045318875392">
     </a>
     <p>
      The automatic limit for rows in a join when using
      <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
       <code class="option">
        --safe-updates
       </code>
      </a>
      . (Default value
            is 1,000,000.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_named-commands">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_named-commands">
       <code class="option">
        --named-commands
       </code>
      </a>
      ,
      <code class="option">
       -G
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for named-commands">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --named-commands
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Disabled by
         </th>
         <td>
          <code class="literal">
           skip-named-commands
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318861824">
     </a>
     <a class="indexterm" name="idm46045318860336">
     </a>
     <p>
      Enable named
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      commands. Long-format
            commands are permitted, not just short-format commands. For
            example,
      <code class="literal">
       quit
      </code>
      and
      <code class="literal">
       \q
      </code>
      both are recognized. Use
      <a class="link" href="mysql-command-options.html#option_mysql_named-commands">
       <code class="option">
        --skip-named-commands
       </code>
      </a>
      to disable named commands. See
      <a class="xref" href="mysql-commands.html" title="6.5.1.2 mysql Client Commands">
       Section 6.5.1.2, “mysql Client Commands”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_net-buffer-length">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_net-buffer-length">
       <code class="option">
        --net-buffer-length=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for net-buffer-length">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --net-buffer-length=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           16384
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318841424">
     </a>
     <a class="indexterm" name="idm46045318839920">
     </a>
     <p>
      The buffer size for TCP/IP and socket communication.
            (Default value is 16KB.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_network-namespace">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_network-namespace">
       <code class="option">
        --network-namespace=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for network-namespace">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --network-namespace=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318827840">
     </a>
     <a class="indexterm" name="idm46045318826336">
     </a>
     <p>
      The network namespace to use for TCP/IP connections. If
            omitted, the connection uses the default (global) namespace.
            For information about network namespaces, see
      <a class="xref" href="network-namespace-support.html" title="7.1.14 Network Namespace Support">
       Section 7.1.14, “Network Namespace Support”
      </a>
      .
     </p>
     <p>
      This option is available only on platforms that implement
            network namespace support.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_no-auto-rehash">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_auto-rehash">
       <code class="option">
        --no-auto-rehash
       </code>
      </a>
      ,
      <code class="option">
       -A
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-auto-rehash">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-auto-rehash
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Deprecated
         </th>
         <td>
          Yes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318812720">
     </a>
     <a class="indexterm" name="idm46045318811232">
     </a>
     <p>
      This has the same effect as
      <code class="option">
       --skip-auto-rehash
      </code>
      .
            See the description for
      <a class="link" href="mysql-command-options.html#option_mysql_auto-rehash">
       <code class="option">
        --auto-rehash
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_no-beep">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318799536">
     </a>
     <a class="indexterm" name="idm46045318798048">
     </a>
     <p>
      Do not beep when errors occur.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_no-defaults">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318788400">
     </a>
     <a class="indexterm" name="idm46045318786912">
     </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="mysql-command-options.html#option_mysql_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="mysql-command-options.html#option_mysql_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_mysql_oci-config-file">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_oci-config-file">
       <code class="option">
        --oci-config-file=
        <em class="replaceable">
         <code>
          PATH
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for oci-config-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --oci-config-file
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318765392">
     </a>
     <a class="indexterm" name="idm46045318763904">
     </a>
     <p>
      Alternate path to the Oracle Cloud Infrastructure CLI configuration file. Specify
            the location of the configuration file. If your existing
            default profile is the correct one, you do not need to
            specify this option. However, if you have an existing
            configuration file, with multiple profiles or a different
            default from the tenancy of the user you want to connect
            with, specify this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_one-database">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_one-database">
       <code class="option">
        --one-database
       </code>
      </a>
      ,
      <code class="option">
       -o
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for one-database">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --one-database
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318753360">
     </a>
     <a class="indexterm" name="idm46045318751872">
     </a>
     <p>
      Ignore statements except those that occur while the default
            database is the one named on the command line. This option
            is rudimentary and should be used with care. Statement
            filtering is based only on
      <a class="link" href="use.html" title="15.8.4 USE Statement">
       <code class="literal">
        USE
       </code>
      </a>
      statements.
     </p>
     <p>
      Initially,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      executes statements in
            the input because specifying a database
      <em class="replaceable">
       <code>
        db_name
       </code>
      </em>
      on the command line is
            equivalent to inserting
      <a class="link" href="use.html" title="15.8.4 USE Statement">
       <code class="literal">
        USE
        <em class="replaceable">
         <code>
          db_name
         </code>
        </em>
       </code>
      </a>
      at the
            beginning of the input. Then, for each
      <a class="link" href="use.html" title="15.8.4 USE Statement">
       <code class="literal">
        USE
       </code>
      </a>
      statement encountered,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      accepts or rejects following
            statements depending on whether the database named is the
            one on the command line. The content of the statements is
            immaterial.
     </p>
     <p>
      Suppose that
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      is invoked to process
            this set of statements:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa18514311"><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-sql"><span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> db2<span class="token punctuation">.</span>t2<span class="token punctuation">;</span>
<span class="token keyword">USE</span> db2<span class="token punctuation">;</span>
<span class="token keyword">DROP</span> <span class="token keyword">TABLE</span> db1<span class="token punctuation">.</span>t1<span class="token punctuation">;</span>
<span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> db1<span class="token punctuation">.</span>t1 <span class="token punctuation">(</span>i <span class="token datatype">INT</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">USE</span> db1<span class="token punctuation">;</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> t1 <span class="token punctuation">(</span>i<span class="token punctuation">)</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> db2<span class="token punctuation">.</span>t1 <span class="token punctuation">(</span>j <span class="token datatype">INT</span><span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
     </div>
     <p>
      If the command line is
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql --force --one-database
            db1
        </strong>
       </span>
      </a>
      ,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      handles the input as
            follows:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         The
         <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
          <code class="literal">
           DELETE
          </code>
         </a>
         statement is
                executed because the default database is
         <code class="literal">
          db1
         </code>
         , even though the statement names
                a table in a different database.
        </p>
       </li>
       <li class="listitem">
        <p>
         The
         <a class="link" href="drop-table.html" title="15.1.32 DROP TABLE Statement">
          <code class="literal">
           DROP TABLE
          </code>
         </a>
         and
         <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
          <code class="literal">
           CREATE TABLE
          </code>
         </a>
         statements
                are not executed because the default database is not
         <code class="literal">
          db1
         </code>
         , even though the statements name
                a table in
         <code class="literal">
          db1
         </code>
         .
        </p>
       </li>
       <li class="listitem">
        <p>
         The
         <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
          <code class="literal">
           INSERT
          </code>
         </a>
         and
         <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
          <code class="literal">
           CREATE TABLE
          </code>
         </a>
         statements
                are executed because the default database is
         <code class="literal">
          db1
         </code>
         , even though the
         <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
          <code class="literal">
           CREATE TABLE
          </code>
         </a>
         statement
                names a table in a different database.
        </p>
       </li>
      </ul>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_pager">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_pager">
       <code class="option">
        --pager[=
        <em class="replaceable">
         <code>
          command
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pager">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pager[=command]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Disabled by
         </th>
         <td>
          <code class="literal">
           skip-pager
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318710560">
     </a>
     <a class="indexterm" name="idm46045318709072">
     </a>
     <p>
      Use the given command for paging query output. If the
            command is omitted, the default pager is the value of your
      <code class="literal">
       PAGER
      </code>
      environment variable. Valid pagers
            are
      <span class="command">
       <strong>
        less
       </strong>
      </span>
      ,
      <span class="command">
       <strong>
        more
       </strong>
      </span>
      ,
      <span class="command">
       <strong>
        cat [&gt; filename]
       </strong>
      </span>
      , and so forth. This
            option works only on Unix and only in interactive mode. To
            disable paging, use
      <a class="link" href="mysql-command-options.html#option_mysql_pager">
       <code class="option">
        --skip-pager
       </code>
      </a>
      .
      <a class="xref" href="mysql-commands.html" title="6.5.1.2 mysql Client Commands">
       Section 6.5.1.2, “mysql Client Commands”
      </a>
      , discusses output paging
            further.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_password">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318691392">
     </a>
     <a class="indexterm" name="idm46045318689904">
     </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="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="mysql-command-options.html#option_mysql_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="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      should not prompt for one, use the
      <a class="link" href="mysql-command-options.html#option_mysql_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_password1">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_password1">
       <code class="option">
        --password1[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045318678112">
     </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="mysql-command-options.html#option_mysql_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="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      should not prompt for one, use the
      <a class="link" href="mysql-command-options.html#option_mysql_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      option.
     </p>
     <p>
      <a class="link" href="mysql-command-options.html#option_mysql_password1">
       <code class="option">
        --password1
       </code>
      </a>
      and
      <a class="link" href="mysql-command-options.html#option_mysql_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_mysql_password2">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_password2">
       <code class="option">
        --password2[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045318662832">
     </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="mysql-command-options.html#option_mysql_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_password3">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_password3">
       <code class="option">
        --password3[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045318657568">
     </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="mysql-command-options.html#option_mysql_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_pipe">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318644784">
     </a>
     <a class="indexterm" name="idm46045318643296">
     </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_mysql_plugin-authentication-kerberos-client-mode">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_plugin-authentication-kerberos-client-mode">
       <code class="option">
        --plugin-authentication-kerberos-client-mode=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for plugin-authentication-kerberos-client-mode">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --plugin-authentication-kerberos-client-mode
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           SSPI
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            GSSAPI
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            SSPI
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318622064">
     </a>
     <a class="indexterm" name="idm46045318620544">
     </a>
     <p>
      On Windows, the
      <code class="literal">
       authentication_kerberos_client
      </code>
      authentication plugin supports this plugin option. It
            provides two possible values that the client user can set at
            runtime:
      <code class="literal">
       SSPI
      </code>
      and
      <code class="literal">
       GSSAPI
      </code>
      .
     </p>
     <p>
      The default value for the client-side plugin option uses
            Security Support Provider Interface (SSPI), which is capable
            of acquiring credentials from the Windows in-memory cache.
            Alternatively, the client user can select a mode that
            supports Generic Security Service Application Program
            Interface (GSSAPI) through the MIT Kerberos library on
            Windows. GSSAPI is capable of acquiring cached credentials
            previously generated by using the
      <span class="command">
       <strong>
        kinit
       </strong>
      </span>
      command.
     </p>
     <p>
      For more information, see
      <a class="link" href="kerberos-pluggable-authentication.html#kerberos-usage-win-gssapi-client-commands">
       Commands
            for Windows Clients in GSSAPI Mode
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_plugin-authentication-webauthn-client-preserve-privacy">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_plugin-authentication-webauthn-client-preserve-privacy">
       <code class="option">
        --plugin-authentication-webauthn-client-preserve-privacy={OFF|ON}
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for plugin-authentication-webauthn-client-preserve-privacy">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --plugin-authentication-webauthn-client-preserve-privacy
          </code>
         </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="idm46045318600672">
     </a>
     <a class="indexterm" name="idm46045318599136">
     </a>
     <p>
      Determines how assertions are sent to server in case there
            is more than one discoverable credential stored for a given
            RP ID (a unique name given to the relying-party server,
            which is the MySQL server). If the FIDO2 device contains
            multiple resident keys for a given RP ID, this option allows
            the user to choose a key to be used for assertion. It
            provides two possible values that the client user can set.
            The default value is
      <code class="literal">
       OFF
      </code>
      . If set to
      <code class="literal">
       OFF
      </code>
      , the challenge is signed by all
            credentials available for a given RP ID and all signatures
            are sent to server. If set to
      <code class="literal">
       ON
      </code>
      , the
            user is prompted to choose the credential to be used for
            signature.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       This option has no effect if the device does not support
              the resident-key feature.
      </p>
     </div>
     <p>
      For more information, see
      <a class="xref" href="webauthn-pluggable-authentication.html" title="8.4.1.11 WebAuthn Pluggable Authentication">
       Section 8.4.1.11, “WebAuthn Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_plugin-dir">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318582320">
     </a>
     <a class="indexterm" name="idm46045318580832">
     </a>
     <p>
      The directory in which to look for plugins. Specify this
            option if the
      <a class="link" href="mysql-command-options.html#option_mysql_default-auth">
       <code class="option">
        --default-auth
       </code>
      </a>
      option is used to specify an authentication plugin but
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </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_mysql_port">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318562720">
     </a>
     <a class="indexterm" name="idm46045318561232">
     </a>
     <a class="indexterm" name="idm46045318559744">
     </a>
     <p>
      For TCP/IP connections, the port number to use.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_print-defaults">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318550496">
     </a>
     <a class="indexterm" name="idm46045318549008">
     </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_mysql_prompt">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_prompt">
       <code class="option">
        --prompt=
        <em class="replaceable">
         <code>
          format_str
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for prompt">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --prompt=format_str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           mysql&gt;
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318533424">
     </a>
     <a class="indexterm" name="idm46045318531936">
     </a>
     <p>
      Set the prompt to the specified format. The default is
      <code class="literal">
       mysql&gt;
      </code>
      . The special sequences that the
            prompt can contain are described in
      <a class="xref" href="mysql-commands.html" title="6.5.1.2 mysql Client Commands">
       Section 6.5.1.2, “mysql Client Commands”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_protocol">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318510720">
     </a>
     <a class="indexterm" name="idm46045318509232">
     </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_mysql_quick">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_quick">
       <code class="option">
        --quick
       </code>
      </a>
      ,
      <code class="option">
       -q
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for quick">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --quick
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318498368">
     </a>
     <a class="indexterm" name="idm46045318496880">
     </a>
     <p>
      Do not cache each query result, print each row as it is
            received. This may slow down the server if the output is
            suspended. With this option,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      does
            not use the history file.
     </p>
     <p>
      By default,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      fetches all result rows
            before producing any output; while storing these, it
            calculates a running maximum column length from the actual
            value of each column in succession. When printing the
            output, it uses this maximum to format it. When
      <code class="option">
       --quick
      </code>
      is specified,
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      does not have the rows for which to
            calculate the length before starting, and so uses the
            maximum length. In the following example, table
      <code class="literal">
       t1
      </code>
      has a single column of type
      <a class="link" href="integer-types.html" title="13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT">
       <code class="literal">
        BIGINT
       </code>
      </a>
      and containing 4 rows.
            The default output is 9 characters wide; this width is equal
            the maximum number of characters in any of the column values
            in the rows returned (5), plus 2 characters each for the
            spaces used as padding and the
      <code class="literal">
       |
      </code>
      characters used as column delimiters). The output when using
            the
      <code class="option">
       --quick
      </code>
      option is 25 characters wide;
            this is equal to the number of characters needed to
            represent
      <code class="literal">
       -9223372036854775808
      </code>
      , which is
            the longest possible value that can be stored in a (signed)
      <code class="literal">
       BIGINT
      </code>
      column, or 19 characters, plus the
            4 characters used for padding and column delimiters. The
            difference can be seen here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa93620902"><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">mysql</span> <span class="token property">-t</span> test <span class="token property">-e</span> <span class="token atrule">"SELECT * FROM t1"</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>
<span class="token output"><span class="token punctuation">|</span> c1    <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>
<span class="token output"><span class="token punctuation">|</span>   100 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  1000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>    10 <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>

<span class="token prompt">$&gt; </span><span class="token command">mysql</span> <span class="token property">--quick</span> <span class="token property">-t</span> test <span class="token property">-e</span> <span class="token atrule">"SELECT * FROM t1"</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>
<span class="token output"><span class="token punctuation">|</span> c1                   <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>
<span class="token output"><span class="token punctuation">|</span>                  100 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>                 1000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>                10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>                   10 <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></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_raw">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_raw">
       <code class="option">
        --raw
       </code>
      </a>
      ,
      <code class="option">
       -r
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for raw">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --raw
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318473728">
     </a>
     <a class="indexterm" name="idm46045318472240">
     </a>
     <p>
      For tabular output, the
      <span class="quote">
       “
       <span class="quote">
        boxing
       </span>
       ”
      </span>
      around columns
            enables one column value to be distinguished from another.
            For nontabular output (such as is produced in batch mode or
            when the
      <a class="link" href="mysql-command-options.html#option_mysql_batch">
       <code class="option">
        --batch
       </code>
      </a>
      or
      <a class="link" href="mysql-command-options.html#option_mysql_silent">
       <code class="option">
        --silent
       </code>
      </a>
      option is given),
            special characters are escaped in the output so they can be
            identified easily. Newline, tab,
      <code class="literal">
       NUL
      </code>
      , and
            backslash are written as
      <code class="literal">
       \n
      </code>
      ,
      <code class="literal">
       \t
      </code>
      ,
      <code class="literal">
       \0
      </code>
      , and
      <code class="literal">
       \\
      </code>
      . The
      <a class="link" href="mysql-command-options.html#option_mysql_raw">
       <code class="option">
        --raw
       </code>
      </a>
      option disables this
            character escaping.
     </p>
     <p>
      The following example demonstrates tabular versus nontabular
            output and the use of raw mode to disable escaping:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa92588213"><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-sql"><span class="token operator">%</span> mysql
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">92</span><span class="token punctuation">)</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> CHAR(92) <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>
<span class="token output"><span class="token punctuation">|</span> \        <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>

<span class="token operator">%</span> mysql <span class="token operator">-</span>s
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">92</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">92</span><span class="token punctuation">)</span>
\\

<span class="token operator">%</span> mysql <span class="token operator">-</span>s <span class="token operator">-</span>r
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">92</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">92</span><span class="token punctuation">)</span>
\</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_reconnect">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_reconnect">
       <code class="option">
        --reconnect
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for reconnect">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --reconnect
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Disabled by
         </th>
         <td>
          <code class="literal">
           skip-reconnect
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318449120">
     </a>
     <a class="indexterm" name="idm46045318447632">
     </a>
     <p>
      If the connection to the server is lost, automatically try
            to reconnect. A single reconnect attempt is made each time
            the connection is lost. To suppress reconnection behavior,
            use
      <a class="link" href="mysql-command-options.html#option_mysql_reconnect">
       <code class="option">
        --skip-reconnect
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_register-factor">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_register-factor">
       <code class="option">
        --register-factor=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for register-factor">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --register-factor=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318434496">
     </a>
     <a class="indexterm" name="idm46045318433008">
     </a>
     <p>
      The factor or factors for which FIDO/FIDO2 device
            registration must be performed before WebAuthn device-based
            authentication can be used. This option value must be a
            single value, or two values separated by commas. Each value
            must be 2 or 3, so the permitted option values are
      <code class="literal">
       '2'
      </code>
      ,
      <code class="literal">
       '3'
      </code>
      ,
      <code class="literal">
       '2,3'
      </code>
      and
      <code class="literal">
       '3,2'
      </code>
      .
     </p>
     <p>
      For example, an account that requires registration for a
            third authentication factor invokes the
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      client as follows:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa26471070"><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">mysql <span class="token constant">--user</span><span class="token attr-value"><span class="token punctuation">=</span><em class="replaceable">user_name</em></span> <span class="token constant">--register-factor</span><span class="token attr-value"><span class="token punctuation">=</span>3</span></code></pre>
     </div>
     <p>
      An account that requires registration for second and third
            authentication factors invokes the
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      client as follows:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa53474"><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">mysql <span class="token constant">--user</span><span class="token attr-value"><span class="token punctuation">=</span><em class="replaceable">user_name</em></span> <span class="token constant">--register-factor</span><span class="token attr-value"><span class="token punctuation">=</span>2,3</span></code></pre>
     </div>
     <p>
      If registration is successful, a connection is established.
            If there is an authentication factor with a pending
            registration, a connection is placed into pending
            registration mode when attempting to connect to the server.
            In this case, disconnect and reconnect with the correct
      <a class="link" href="mysql-command-options.html#option_mysql_register-factor">
       <code class="option">
        --register-factor
       </code>
      </a>
      value to
            complete the registration.
     </p>
     <p>
      Registration is a two-step process comprising
      <span class="emphasis">
       <em>
        initiate registration
       </em>
      </span>
      and
      <span class="emphasis">
       <em>
        finish registration
       </em>
      </span>
      steps. The initiate
            registration step executes this statement:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa73890961"><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-sql"><span class="token keyword">ALTER</span> <span class="token keyword">USER</span> <span class="token keyword"><em class="replaceable">user</em></span> <em class="replaceable">factor</em> INITIATE REGISTRATION</code></pre>
     </div>
     <p>
      The statement returns a result set containing a 32 byte
            challenge, the user name, and the relying party ID (see
      <a class="link" href="pluggable-authentication-system-variables.html#sysvar_authentication_webauthn_rp_id">
       <code class="literal">
        authentication_webauthn_rp_id
       </code>
      </a>
      ).
     </p>
     <p>
      The finish registration step executes this statement:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa69137336"><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-sql"><span class="token keyword">ALTER</span> <span class="token keyword">USER</span> <span class="token keyword"><em class="replaceable">user</em></span> <em class="replaceable">factor</em> FINISH REGISTRATION <span class="token keyword">SET</span> CHALLENGE_RESPONSE <span class="token keyword">AS</span> <span class="token string">'<em class="replaceable">auth_string</em>'</span></code></pre>
     </div>
     <p>
      The statement completes the registration and sends the
            following information to the server as part of the
      <em class="replaceable">
       <code>
        auth_string
       </code>
      </em>
      : authenticator data,
            an optional attestation certificate in X.509 format, and a
            signature.
     </p>
     <p>
      The initiate and registration steps must be performed in a
            single connection, as the challenge received by the client
            during the initiate step is saved to the client connection
            handler. Registration would fail if the registration step
            was performed by a different connection. The
      <a class="link" href="mysql-command-options.html#option_mysql_register-factor">
       <code class="option">
        --register-factor
       </code>
      </a>
      option
            executes both the initiate and registration steps, which
            avoids the failure scenario described above and prevents
            having to execute the
      <a class="link" href="alter-user.html" title="15.7.1.1 ALTER USER Statement">
       <code class="literal">
        ALTER
            USER
       </code>
      </a>
      initiate and registration statements
            manually.
     </p>
     <p>
      The
      <a class="link" href="mysql-command-options.html#option_mysql_register-factor">
       <code class="option">
        --register-factor
       </code>
      </a>
      option
            is only available for the
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      and
            MySQL Shell clients. Other MySQL client programs do not
            support it.
     </p>
     <p>
      For related information, see
      <a class="xref" href="webauthn-pluggable-authentication.html#webauthn-pluggable-authentication-usage" title="Using WebAuthn Authentication">
       Using WebAuthn Authentication
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_safe-updates">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
       <code class="option">
        --safe-updates
       </code>
      </a>
      ,
      <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
       <code class="option">
        --i-am-a-dummy
       </code>
      </a>
      ,
      <code class="option">
       -U
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for safe-updates">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            --safe-updates
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            --i-am-a-dummy
           </code>
          </p>
         </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="idm46045318388624">
     </a>
     <a class="indexterm" name="idm46045318387136">
     </a>
     <a class="indexterm" name="idm46045318385648">
     </a>
     <a class="indexterm" name="idm46045318384160">
     </a>
     <p>
      If this option is enabled,
      <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
       <code class="literal">
        UPDATE
       </code>
      </a>
      and
      <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
       <code class="literal">
        DELETE
       </code>
      </a>
      statements that do not
            use a key in the
      <code class="literal">
       WHERE
      </code>
      clause or a
      <code class="literal">
       LIMIT
      </code>
      clause produce an error. In
            addition, restrictions are placed on
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statements that
            produce (or are estimated to produce) very large result
            sets. If you have set this option in an option file, you can
            use
      <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
       <code class="option">
        --skip-safe-updates
       </code>
      </a>
      on the command line to override it. For more information
            about this option, see
      <a class="xref" href="mysql-tips.html#safe-updates" title="Using Safe-Updates Mode (--safe-updates)">
       Using Safe-Updates Mode (--safe-updates)
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_select-limit">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_select-limit">
       <code class="option">
        --select-limit=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for select-limit">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --select-limit=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1000
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318362352">
     </a>
     <a class="indexterm" name="idm46045318360864">
     </a>
     <p>
      The automatic limit for
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statements when using
      <a class="link" href="mysql-command-options.html#option_mysql_safe-updates">
       <code class="option">
        --safe-updates
       </code>
      </a>
      . (Default value
            is 1,000.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_server-public-key-path">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318346576">
     </a>
     <a class="indexterm" name="idm46045318345072">
     </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="mysql-command-options.html#option_mysql_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="mysql-command-options.html#option_mysql_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_mysql_shared-memory-base-name">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318323728">
     </a>
     <a class="indexterm" name="idm46045318322224">
     </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_mysql_show-warnings">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318309904">
     </a>
     <a class="indexterm" name="idm46045318308416">
     </a>
     <p>
      Cause warnings to be shown after each statement if there are
            any. This option applies to interactive and batch mode.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_sigint-ignore">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_sigint-ignore">
       <code class="option">
        --sigint-ignore
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sigint-ignore">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sigint-ignore
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318298656">
     </a>
     <a class="indexterm" name="idm46045318297168">
     </a>
     <p>
      Ignore
      <code class="literal">
       SIGINT
      </code>
      signals (typically the
            result of typing
      <span class="keycap">
       <strong>
        Control+C
       </strong>
      </span>
      ).
     </p>
     <p>
      Without this option, typing
      <span class="keycap">
       <strong>
        Control+C
       </strong>
      </span>
      interrupts the current statement if there is one, or cancels
            any partial input line otherwise.
     </p>
     <a class="indexterm" name="idm46045318292512">
     </a>
     <a class="indexterm" name="idm46045318291024">
     </a>
     <a class="indexterm" name="idm46045318289536">
     </a>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_silent">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318279984">
     </a>
     <a class="indexterm" name="idm46045318278496">
     </a>
     <p>
      Silent mode. Produce less output. This option can be given
            multiple times to produce less and less output.
     </p>
     <p>
      This option results in nontabular output format and escaping
            of special characters. Escaping may be disabled by using raw
            mode; see the description for the
      <a class="link" href="mysql-command-options.html#option_mysql_raw">
       <code class="option">
        --raw
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_skip-column-names">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_skip-column-names">
       <code class="option">
        --skip-column-names
       </code>
      </a>
      ,
      <code class="option">
       -N
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for skip-column-names">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --skip-column-names
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318266720">
     </a>
     <a class="indexterm" name="idm46045318265216">
     </a>
     <p>
      Do not write column names in results. Use of this option
            causes the output to be right-aligned, as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa97922444"><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">echo</span> <span class="token atrule">"SELECT * FROM t1"</span> | mysql <span class="token property">-t</span> test
<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>
<span class="token output"><span class="token punctuation">|</span> c1    <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>
<span class="token output"><span class="token punctuation">|</span> a,c,d <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> c     <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>
<span class="token prompt">$&gt; </span><span class="token command">echo</span> <span class="token atrule">"SELECT * FROM t1"</span> | <span class="token punctuation">.</span>/mysql <span class="token property">-uroot</span> <span class="token property">-Nt</span> test
<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>
<span class="token output"><span class="token punctuation">|</span> a,c,d <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>     c <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></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_skip-line-numbers">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_skip-line-numbers">
       <code class="option">
        --skip-line-numbers
       </code>
      </a>
      ,
      <code class="option">
       -L
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for skip-line-numbers">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --skip-line-numbers
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318252448">
     </a>
     <a class="indexterm" name="idm46045318250944">
     </a>
     <p>
      Do not write line numbers for errors. Useful when you want
            to compare result files that include error messages.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_skip-system-command">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_skip-system-command">
       <code class="option">
        --skip-system-command
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for skip-system-command">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --skip-system-command
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Introduced
         </th>
         <td>
          8.4.3
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318239136">
     </a>
     <a class="indexterm" name="idm46045318237632">
     </a>
     <p>
      Disables the
      <code class="literal">
       system
      </code>
      (
      <code class="literal">
       \!
      </code>
      ) command. Equivalent to
      <a class="link" href="mysql-command-options.html#option_mysql_system-command">
       <code class="option">
        --system-command=OFF
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_socket">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318222544">
     </a>
     <a class="indexterm" name="idm46045318221056">
     </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_mysql_ssl">
      </a>
      <code class="option">
       --ssl*
      </code>
     </p>
     <a class="indexterm" name="idm46045318213472">
     </a>
     <a class="indexterm" name="idm46045318211984">
     </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_mysql_ssl-fips-mode">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318189840">
     </a>
     <a class="indexterm" name="idm46045318188352">
     </a>
     <p>
      Controls whether to enable FIPS mode on the client side. The
      <a class="link" href="mysql-command-options.html#option_mysql_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="mysql-command-options.html#option_mysql_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="mysql-command-options.html#option_mysql_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="mysql-command-options.html#option_mysql_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_mysql_syslog">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_syslog">
       <code class="option">
        --syslog
       </code>
      </a>
      ,
      <code class="option">
       -j
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for syslog">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --syslog
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318163440">
     </a>
     <a class="indexterm" name="idm46045318161952">
     </a>
     <p>
      This option causes
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      to send
            interactive statements to the system logging facility. On
            Unix, this is
      <code class="literal">
       syslog
      </code>
      ; on Windows, it is
            the Windows Event Log. The destination where logged messages
            appear is system dependent. On Linux, the destination is
            often the
      <code class="filename">
       /var/log/messages
      </code>
      file.
     </p>
     <p>
      Here is a sample of output generated on Linux by using
      <code class="option">
       --syslog
      </code>
      . This output is formatted for
            readability; each logged message actually takes a single
            line.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-none"><div class="docs-select-all right" id="sa14381557"><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-none">Mar  7 12:39:25 myhost MysqlClient[20824]:
  SYSTEM_USER:'oscar', MYSQL_USER:'my_oscar', CONNECTION_ID:23,
  DB_SERVER:'127.0.0.1', DB:'--', QUERY:'USE test;'
Mar  7 12:39:28 myhost MysqlClient[20824]:
  SYSTEM_USER:'oscar', MYSQL_USER:'my_oscar', CONNECTION_ID:23,
  DB_SERVER:'127.0.0.1', DB:'test', QUERY:'SHOW TABLES;'</code></pre>
     </div>
     <p>
      For more information, see
      <a class="xref" href="mysql-logging.html" title="6.5.1.3 mysql Client Logging">
       Section 6.5.1.3, “mysql Client Logging”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_system-command">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_system-command">
       <code class="option">
        --system-command[={ON|OFF}]
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for system-command">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --system-command[={ON|OFF}]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Introduced
         </th>
         <td>
          8.4.3
         </td>
        </tr>
        <tr>
         <th>
          Disabled by
         </th>
         <td>
          <code class="literal">
           skip-system-command
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           ON
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318136976">
     </a>
     <a class="indexterm" name="idm46045318135488">
     </a>
     <p>
      Enable or disable the
      <code class="literal">
       system
      </code>
      (
      <code class="literal">
       \!
      </code>
      ) command. When this option is
            disabled, either by
      <code class="option">
       --system-command=OFF
      </code>
      or
            by
      <a class="link" href="mysql-command-options.html#option_mysql_skip-system-command">
       <code class="option">
        --skip-system-command
       </code>
      </a>
      , the
      <code class="literal">
       system
      </code>
      command is rejected with an error.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_table">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_table">
       <code class="option">
        --table
       </code>
      </a>
      ,
      <code class="option">
       -t
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for table">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --table
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318121856">
     </a>
     <a class="indexterm" name="idm46045318120368">
     </a>
     <p>
      Display output in table format. This is the default for
            interactive use, but can be used to produce table output in
            batch mode.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_tee">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_tee">
       <code class="option">
        --tee=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tee">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tee=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318108336">
     </a>
     <a class="indexterm" name="idm46045318106848">
     </a>
     <p>
      Append a copy of output to the given file. This option works
            only in interactive mode.
      <a class="xref" href="mysql-commands.html" title="6.5.1.2 mysql Client Commands">
       Section 6.5.1.2, “mysql Client Commands”
      </a>
      ,
            discusses tee files further.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_tls-ciphersuites">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318094080">
     </a>
     <a class="indexterm" name="idm46045318092592">
     </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_mysql_tls-sni-servername">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318079600">
     </a>
     <a class="indexterm" name="idm46045318078096">
     </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_mysql_tls-version">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318057152">
     </a>
     <a class="indexterm" name="idm46045318055664">
     </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_mysql_unbuffered">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_unbuffered">
       <code class="option">
        --unbuffered
       </code>
      </a>
      ,
      <code class="option">
       -n
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for unbuffered">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --unbuffered
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045318044656">
     </a>
     <a class="indexterm" name="idm46045318043168">
     </a>
     <p>
      Flush the buffer after each query.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_user">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318030544">
     </a>
     <a class="indexterm" name="idm46045318029056">
     </a>
     <p>
      The user name of the MySQL account to use for connecting to
            the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_verbose">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318019040">
     </a>
     <a class="indexterm" name="idm46045318017552">
     </a>
     <p>
      Verbose mode. Produce more output about what the program
            does. This option can be given multiple times to produce
            more and more output. (For example,
      <code class="option">
       -v -v
            -v
      </code>
      produces table output format even in batch
            mode.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_version">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045318006944">
     </a>
     <a class="indexterm" name="idm46045318005456">
     </a>
     <p>
      Display version information and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_vertical">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045317995456">
     </a>
     <a class="indexterm" name="idm46045317993968">
     </a>
     <p>
      Print query output rows vertically (one line per column
            value). Without this option, you can specify vertical output
            for individual statements by terminating them with
      <code class="literal">
       \G
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_wait">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_wait">
       <code class="option">
        --wait
       </code>
      </a>
      ,
      <code class="option">
       -w
      </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="idm46045317983104">
     </a>
     <a class="indexterm" name="idm46045317981616">
     </a>
     <p>
      If the connection cannot be established, wait and retry
            instead of aborting.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_xml">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_xml">
       <code class="option">
        --xml
       </code>
      </a>
      ,
      <code class="option">
       -X
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for xml">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --xml
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045317971552">
     </a>
     <a class="indexterm" name="idm46045317970064">
     </a>
     <p>
      Produce XML output.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-xml"><div class="docs-select-all right" id="sa50428682"><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-xml"><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>field</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><em class="replaceable">column_name</em><span class="token punctuation">"</span></span><span class="token punctuation">&gt;</span></span>NULL<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>field</span><span class="token punctuation">&gt;</span></span></code></pre>
     </div>
     <p>
      The output when
      <a class="link" href="mysql-command-options.html#option_mysql_xml">
       <code class="option">
        --xml
       </code>
      </a>
      is used
            with
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      matches that of
      <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
       <span class="command">
        <strong>
         mysqldump
        </strong>
       </span>
      </a>
      <a class="link" href="mysqldump.html#option_mysqldump_xml">
       <code class="option">
        --xml
       </code>
      </a>
      . See
      <a class="xref" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
       Section 6.5.4, “mysqldump — A Database Backup Program”
      </a>
      , for details.
     </p>
     <p>
      The XML output also uses an XML namespace, as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa33505153"><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">mysql</span> <span class="token property">--xml</span> <span class="token property">-uroot</span> <span class="token property">-e</span> <span class="token atrule">"SHOW VARIABLES LIKE 'version%'"</span>
&lt;?xml version=<span class="token atrule">"1.0"</span>?&gt;

&lt;resultset statement=<span class="token atrule">"SHOW VARIABLES LIKE 'version%'"</span> xmlns<span class="token punctuation">:</span>xsi=<span class="token atrule">"http://www.w3.org/2001/XMLSchema-instance"</span>&gt;
&lt;row&gt;
&lt;field name=<span class="token atrule">"Variable_name"</span>&gt;version&lt;/field&gt;
&lt;field name=<span class="token atrule">"Value"</span>&gt;5<span class="token punctuation">.</span>0<span class="token punctuation">.</span>40-debug&lt;/field&gt;
&lt;/row&gt;

&lt;row&gt;
&lt;field name=<span class="token atrule">"Variable_name"</span>&gt;version_comment&lt;/field&gt;
&lt;field name=<span class="token atrule">"Value"</span>&gt;Source distribution&lt;/field&gt;
&lt;/row&gt;

&lt;row&gt;
&lt;field name=<span class="token atrule">"Variable_name"</span>&gt;version_compile_machine&lt;/field&gt;
&lt;field name=<span class="token atrule">"Value"</span>&gt;i686&lt;/field&gt;
&lt;/row&gt;

&lt;row&gt;
&lt;field name=<span class="token atrule">"Variable_name"</span>&gt;version_compile_os&lt;/field&gt;
&lt;field name=<span class="token atrule">"Value"</span>&gt;suse-linux-gnu&lt;/field&gt;
&lt;/row&gt;
&lt;/resultset&gt;</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysql_zstd-compression-level">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_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="idm46045317948192">
     </a>
     <a class="indexterm" name="idm46045317946688">
     </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>
    <li class="listitem">
     <p>
      <a name="option_mysql_telemetry_client">
      </a>
      <a class="link" href="mysql-command-options.html#option_mysql_telemetry_client">
       <code class="option">
        telemetry_client
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045317938848">
     </a>
     <a class="indexterm" name="idm46045317937360">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for telemetry_client">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --telemetry_client
          </code>
         </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>
     <p>
      Enables the telemetry client plugin (Linux only).
     </p>
     <p>
      For more information, see
      <a class="xref" href="telemetry.html" title="Chapter 35 Telemetry">
       Chapter 35,
       <i>
        Telemetry
       </i>
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
