Disable \r\n - to - \n translation and treatment of \0 as end-of-query
--bind-address <command>
Use specified network interface to connect to MySQL Server
--character-sets-dir <command>
Directory where character sets are installed
--column-names
Write column names in results
--column-type-info
Display result set metadata
--comments,-c
Whether to retain or strip comments in statements sent to the server
--compress,-C
Compress all information sent between client and server
--compression-algorithms <command>
Permitted compression algorithms for connections to server
--connect-expired-password
Indicate to server that client can handle expired-password sandbox mode
--connect-timeout <command>
Number of seconds before connection timeout
-D,--database <command>
The database to use
--debug
Write debugging log; supported only if MySQL was built with debugging support
--debug-check
Print debugging information when program exits
-T,--debug-info
Print debugging information, memory, and CPU statistics when program exits
--default-auth <command>
Authentication plugin to use
--default-character-set <command>
Specify default character set
--defaults-extra-file <command>
Read named option file in addition to usual option files
--defaults-file <command>
Read only named option file
--defaults-group-suffix <command>
Option group suffix value
--delimiter <command>
Set the statement delimiter
--disable-named-commands
Disable named commands. Use the \* form only, or use named commands only at the beginning of a line ending with a semicolon (;). mysql starts with this option enabled by default. However, even with this option, long-format commands still work from the first line
--dns-srv-name <command>
Use DNS SRV lookup for host information
--enable-cleartext-plugin
Enable cleartext authentication plugin
-e,--execute <command>
Execute the statement and quit
-f,--force
Continue even if an SQL error occurs
--get-server-public-key
Request RSA public key from server
--help,-?
Display help message and exit
--histignore
Patterns specifying which statements to ignore for logging
-h,--host <command>
Host on which MySQL server is located
-H,--html
Produce HTML output
-i,--ignore-spaces
Ignore spaces after function names
--init-command <command>
SQL statement to execute after connecting
--line-numbers
Write line numbers for errors
--load-data-local-dir <command>
Directory for files named in LOAD DATA LOCAL statements
--local-infile <command>
Enable or disable for LOCAL capability for LOAD DATA
--login-path <command>
Read login path options from .mylogin.cnf
--max-allowed-packet <command>
Maximum packet length to send to or receive from server
--max-join-size <command>
The automatic limit for rows in a join when using --safe-updates
-G,--named-commands
Enable named mysql commands
--net-buffer-length <command>
Buffer size for TCP/IP and socket communication
--network-namespace <command>
Specify network namespace
-A,--no-auto-rehash
Disable automatic rehashing
--no-beep,-b
Do not beep when errors occur
--no-defaults
Read no option files
-o,--one-database
Ignore statements except those for the default database named on the command line
--pager <command>
Use the given command for paging query output
-p,--password <command>
Password to use when connecting to server
--pipe,-W
Connect to server using named pipe (Windows only)
--plugin-dir <command>
Directory where plugins are installed
-P,--port <command>
TCP/IP port number for connection
--print-defaults
Print default options
--prompt <command>
Set the prompt to the specified format
--protocol <command>
Transport protocol to use
-q,--quick
Do not cache each query result
-r,--raw
Write column values without escape conversion
--reconnect
If the connection to the server is lost, automatically try to reconnect
-U,--safe-updates,--i-am-a-dummy
Allow only UPDATE and DELETE statements that specify key values
--select-limit <command>
The automatic limit for SELECT statements when using --safe-updates
--server-public-key-path <command>
Path name to file containing RSA public key
--shared-memory-base-name <command>
Shared-memory name for shared-memory connections (Windows only)
--show-warnings
Show warnings after each statement if there are any
--sigint-ignore
Ignore SIGINT signals (typically the result of typing Control+C)
-s,--silent
Repeatable ♾
--skip-auto-rehash
Disable automatic rehashing
-N,--skip-column-names
Do not write column names in results
-L,--skip-line-numbers
Skip line numbers for errors
--skip-named-commands
Disable named mysql commands
--skip-pager
Disable paging
--skip-reconnect
Disable reconnecting
-S,--socket <command>
Unix socket file or Windows named pipe to use"File that contains list of trusted SSL Certificate Authorities"
--ssl-ca <command>
File that contains list of trusted SSL Certificate Authorities
--ssl-capath <command>
Directory that contains trusted SSL Certificate Authority certificate files
--ssl-cert <command>
File that contains X.509 certificate
--ssl-cipher
Permissible ciphers for connection encryption
--ssl-crl <command>
File that contains certificate revocation lists
--ssl-crlpath <command>
Directory that contains certificate revocation-list files
--ssl-fips-mode <command>
Whether to enable FIPS mode on client side
--ssl-key <command>
File that contains X.509 key
--ssl-mode
Desired security state of connection to server
-j,--syslog
Log interactive statements to syslog
-t,--table
Display output in tabular format
--tee <command>
Append a copy of output to named file
--tls-ciphersuites <command>
Permissible TLSv1.3 ciphersuites for encrypted connections
--tls-version <command>
Permissible TLS protocols for encrypted connections
-n,--unbuffered
Flush the buffer after each query
-u,--user <command>
MySQL user name to use when connecting to server
-v,--verbose
Verbose mode
-V,--version
Display version information and exit
-E,--vertical
Print query output rows vertically (one line per column value)
-w,--wait
If the connection cannot be established, wait and retry instead of aborting
-X,--xml
Produce XML output
--zstd-compression-level <command>
Compression level for connections to server that use zstd compression