mariadb & mysql for MariaDB Enterprise Server 10.4
The mysql utility, which is also called MariaDB Client, provides SQL shell access to MariaDB Enterprise Server 10.4. It supports both interactive and non-interactive use.
MariaDB Enterprise Server 10.4 also provides a symbolic link to the utility's new name (mariadb).
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Enterprise Server 10.4
Topics on this page:
mysql Options for MariaDB Enterprise Server 10.4
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. |
To see options supported in other versions, see "mariadb & mysql Options by MariaDB Server Version".