mysql options in 10.4 ES
Option |
Description |
---|---|
Abort 'source filename' operations in case of errors |
|
Enable automatic rehashing. One doesn't need to use 'rehash' to get table and field completion, but startup and reconnecting may take a longer time. Disable with --disable-auto-rehash. (Defaults to on; use --skip-auto-rehash to disable.) |
|
Automatically switch to vertical output mode if the result is wider than the terminal width. |
|
Don't use history file. Disable interactive behavior. (Enables --silent.) |
|
Print binary data as hex |
|
By default, ASCII '\0' is disallowed and '\r\n' is translated to '\n'. This switch turns off both features, and also turns off parsing of all clientcommands except \C and DELIMITER, in non-interactive mode (for input piped to mysql or loaded using the 'source' command). This is necessary when processing output from mysqlbinlog that may contain blobs. |
|
Directory for character set files. |
|
Write column names in results. (Defaults to on; use --skip-column-names to disable.) |
|
Display column type information. |
|
Preserve comments. Send comments to the server. The default is --skip-comments (discard comments), enable with --comments. |
|
Use compression in server/client protocol. |
|
Notify the server that this client is prepared to handle expired password sandbox mode even if --batch was specified. |
|
Number of seconds before connection timeout. |
|
Database to use. |
|
This is a non-debug version. Catch this and exit. |
|
Check memory and open file usage at exit. |
|
Print some debug info at exit. |
|
Default authentication client-side plugin to use. |
|
Set the default character set. |
|
Read this file after the global files are read. |
|
Only read default options from the given file #. |
|
Additionally read default groups with # appended as a suffix. |
|
Delimiter to be used. |
|
Execute command and quit. (Disables --force and history file.) |
|
Continue even if we get an SQL error. Sets abort-source-on-error to 0 |
|
Display this help and exit. |
|
Connect to host. |
|
Produce HTML output. |
|
Synonym for option --safe-updates, -U. |
|
Ignore space after function names. |
|
SQL Command to execute when connecting to MariaDB server. Will automatically be re-executed when reconnecting. |
|
Write line numbers for errors. (Defaults to on; use --skip-line-numbers to disable.) |
|
Enable/disable LOAD DATA LOCAL INFILE. |
|
The maximum packet length to send to or receive from server. |
|
Automatic limit for rows in a join when using --safe-updates. |
|
Enable named commands. Named commands mean this program's internal commands; see mysql> help . When enabled, the named commands can be used from any line of the query, otherwise only from the first line, before an enter. Disable with --disable-named-commands. This option is disabled by default. |
|
The buffer size for TCP/IP and socket communication. |
|
No automatic rehashing. One has to use 'rehash' to get table and field completion. This gives a quicker start of mysql and disables rehashing on reconnect. |
|
Turn off beep on error. |
|
Don't read default options from any option file. |
|
Ignore statements except those that occur while the default database is the one named at the command line. |
|
Pager to use to display results. If you don't supply an option, the default pager is taken from your ENV variable PAGER. Valid pagers are less, more, cat [> filename], etc. See interactive help (\h) also. This option does not work in batch mode. Disable with --disable-pager. This option is disabled by default. |
|
Password to use when connecting to server. If password is not given it's asked from the tty. |
|
Directory for client-side plugins. |
|
Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306). |
|
Print the program argument list and exit. |
|
Get progress reports for long running commands (like ALTER TABLE) (Defaults to on; use --skip-progress-reports to disable.) |
|
Set the command line prompt to this value. |
|
The protocol to use for connection (tcp, socket, pipe). |
|
Don't cache result, print it row by row. This may slow down the server if the output is suspended. Doesn't use history file. |
|
Write fields without conversion. Used with --batch. |
|
Reconnect if the connection is lost. Disable with --disable-reconnect. This option is enabled by default. (Defaults to on; use --skip-reconnect to disable.) |
|
Only allow UPDATE and DELETE that uses keys. |
|
Refuse client connecting to server if it uses old (pre-4.1.1) protocol. |
|
Automatic limit for SELECT when using --safe-updates. |
|
Send embedded server this as a parameter. |
|
Show warnings after every statement. |
|
Ignore SIGINT (CTRL-C). |
|
Be more silent. Print results with a tab as separator, each row on new line. |
|
Don't write column names in results. |
|
Don't write line number for errors. |
|
The socket file to use for connection. |
|
Enable SSL for connection (automatically enabled with other flags). |
|
CA file in PEM format (check OpenSSL docs, implies --ssl). |
|
CA directory (check OpenSSL docs, implies --ssl). |
|
X509 cert in PEM format (implies --ssl). |
|
SSL cipher to use (implies --ssl). |
|
Certificate revocation list (implies --ssl). |
|
Certificate revocation list path (implies --ssl). |
|
X509 key in PEM format (implies --ssl). |
|
Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. |
|
Output in table format. |
|
Append everything into outfile. See interactive help (\h) also. Does not work in batch mode. Disable with --disable-tee. This option is disabled by default. |
|
TLS protocol version for secure connection. |
|
Flush buffer after each query. |
|
User for login if not current user. |
|
Write more. (-v -v -v gives the table output format). |
|
Output version information and exit. |
|
Print the output of a query (rows) vertically. |
|
Wait and retry if connection is down. |
|
Produce XML output. |