| --auto-rehash |
Enable automatic rehashing |
|
|
| --auto-vertical-output |
Enable automatic vertical result set display |
|
|
| --batch |
Do not use history file |
|
|
| --binary-as-hex |
Display binary values in hexadecimal notation |
|
|
| --binary-mode |
Disable \r\n - to - \n translation and treatment of \0 as end-of-query |
|
|
| --bind-address |
Use specified network interface to connect to MySQL Server |
|
|
| --character-sets-dir |
Directory where character sets are installed |
|
|
| --column-names |
Write column names in results |
|
|
| --column-type-info |
Display result set metadata |
|
|
| --comments |
Whether to retain or strip comments in statements sent to the server |
|
|
| --compress |
Compress all information sent between client and server |
|
|
| --connect-expired-password |
Indicate to server that client can handle expired-password sandbox mode |
|
|
| --connect-timeout |
Number of seconds before connection timeout |
|
|
| --database |
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 |
|
|
| --debug-info |
Print debugging information, memory, and CPU statistics when program exits |
|
|
| --default-auth |
Authentication plugin to use |
|
|
| --default-character-set |
Specify default character set |
|
|
| --defaults-extra-file |
Read named option file in addition to usual option files |
|
|
| --defaults-file |
Read only named option file |
|
|
| --defaults-group-suffix |
Option group suffix value |
|
|
| --delimiter |
Set the statement delimiter |
|
|
| --enable-cleartext-plugin |
Enable cleartext authentication plugin |
|
|
| --execute |
Execute the statement and quit |
|
|
| --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 |
|
|
| --host |
Host on which MySQL server is located |
|
|
| --html |
Produce HTML output |
|
|
| --ignore-spaces |
Ignore spaces after function names |
|
|
| --init-command |
SQL statement to execute after connecting |
|
|
| --line-numbers |
Write line numbers for errors |
|
|
| --local-infile |
Enable or disable for LOCAL capability for LOAD DATA |
|
|
| --login-path |
Read login path options from .mylogin.cnf |
|
|
| --max-allowed-packet |
Maximum packet length to send to or receive from server |
|
|
| --max-join-size |
The automatic limit for rows in a join when using --safe-updates |
|
|
| --named-commands |
Enable named mysql commands |
|
|
| --net-buffer-length |
Buffer size for TCP/IP and socket communication |
|
|
| --no-auto-rehash |
Disable automatic rehashing |
|
|
| --no-beep |
Do not beep when errors occur |
|
|
| --no-defaults |
Read no option files |
|
|
| --one-database |
Ignore statements except those for the default database named on the command line |
|
|
| --pager |
Use the given command for paging query output |
|
|
| --password |
Password to use when connecting to server |
|
|
| --pipe |
Connect to server using named pipe (Windows only) |
|
|
| --plugin-dir |
Directory where plugins are installed |
|
|
| --port |
TCP/IP port number for connection |
|
|
| --print-defaults |
Print default options |
|
|
| --prompt |
Set the prompt to the specified format |
|
|
| --protocol |
Transport protocol to use |
|
|
| --quick |
Do not cache each query result |
|
|
| --raw |
Write column values without escape conversion |
|
|
| --reconnect |
If the connection to the server is lost, automatically try to reconnect |
|
|
| --safe-updates, --i-am-a-dummy |
Allow only UPDATE and DELETE statements that specify key values |
|
|
| --secure-auth |
Do not send passwords to server in old (pre-4.1) format |
|
|
| --select-limit |
The automatic limit for SELECT statements when using --safe-updates |
|
|
| --server-public-key-path |
Path name to file containing RSA public key |
|
|
| --shared-memory-base-name |
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) |
|
|
| --silent |
Silent mode |
|
|
| --skip-auto-rehash |
Disable automatic rehashing |
|
|
| --skip-column-names |
Do not write column names in results |
|
|
| --skip-line-numbers |
Skip line numbers for errors |
|
|
| --skip-named-commands |
Disable named mysql commands |
|
|
| --skip-pager |
Disable paging |
|
|
| --skip-reconnect |
Disable reconnecting |
|
|
| --socket |
Unix socket file or Windows named pipe to use |
|
|
| --ssl |
Enable connection encryption |
|
|
| --ssl-ca |
File that contains list of trusted SSL Certificate Authorities |
|
|
| --ssl-capath |
Directory that contains trusted SSL Certificate Authority certificate files |
|
|
| --ssl-cert |
File that contains X.509 certificate |
|
|
| --ssl-cipher |
Permissible ciphers for connection encryption |
|
|
| --ssl-crl |
File that contains certificate revocation lists |
|
|
| --ssl-crlpath |
Directory that contains certificate revocation-list files |
|
|
| --ssl-key |
File that contains X.509 key |
|
|
| --ssl-mode |
Desired security state of connection to server |
|
|
| --ssl-verify-server-cert |
Verify host name against server certificate Common Name identity |
|
|
| --syslog |
Log interactive statements to syslog |
|
|
| --table |
Display output in tabular format |
|
|
| --tee |
Append a copy of output to named file |
|
|
| --tls-version |
Permissible TLS protocols for encrypted connections |
|
|
| --unbuffered |
Flush the buffer after each query |
|
|
| --user |
MySQL user name to use when connecting to server |
|
|
| --verbose |
Verbose mode |
|
|
| --version |
Display version information and exit |
|
|
| --vertical |
Print query output rows vertically (one line per column value) |
|
|
| --wait |
If the connection cannot be established, wait and retry instead of aborting |
|
|
| --xml |
Produce XML output |
|
|