--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 | | |