什么是mysql客户机_【练习】显示MYSQL客户机选项

[oracle@enmo ~]$ mysql --help

mysql Ver 14.14 Distrib 5.6.25, forLinux (x86_64) using EditLine wrapper

Copyright (c)2000, 2015, Oracle and/or its affiliates. Allrights reserved.

Oracleis a registered trademark of Oracle Corporation and/orits

affiliates. Other names may be trademarksoftheir respective

owners.

Usage: mysql[OPTIONS] [database]

-?, --help Display this help and exit.

-I, --help Synonym for -?

--auto-rehash Enable automatic rehashing. One doesn't need to use

'rehash' to get table andfield completion, but startupand reconnecting may take a longer time. Disable with

--disable-auto-rehash.

(Defaults to on; use --skip-auto-rehash to disable.)

-A, --no-auto-rehash

No automatic rehashing. One has to use 'rehash' togettable and field completion. This gives a quicker start ofmysqland disables rehashing onreconnect.--auto-vertical-output

Automatically switch to vertical output mode ifthe

resultiswider than the terminal width.-B, --batch Don't use history file. Disable interactive behavior.

(Enables --silent.)

--bind-address=name IP address to bind to.

--character-sets-dir=name

Directory for character setfiles.--column-type-info Display column type information.

-c, --comments Preserve comments. Send comments to the server. The

default is --skip-comments (discard comments), enable

with --comments.

-C, --compress Use compression in server/client protocol.

-#, --debug[=#] This is a non-debug version. Catch this and exit.

--debug-check Check memory and open file usage at exit.

-T, --debug-info Print some debug info at exit.

-D, --database=name Database to use.

--default-character-set=name

Set the default character set.--delimiter=name Delimiter to be used.

--enable-cleartext-plugin

Enable/disable the clear textauthentication plugin.-e, --execute=name Execute command and quit. (Disables --force and history

file.)-E, --vertical Print the output of a query (rows) vertically.

-f, --force Continue even if we get an SQL error.

-G, --named-commands

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.

-i, --ignore-spaces Ignore space after function names.

--init-command=name SQL Command to execute when connecting to MySQL server.

Will automatically be re-executed when reconnecting.

--local-infile Enable/disable LOAD DATA LOCAL INFILE.

-b, --no-beep Turn off beep on error.

-h, --host=name Connect to host.

-H, --html Produce HTML output.

-X, --xml Produce XML output.

--line-numbers Write line numbers for errors.

(Defaults to on; use --skip-line-numbers to disable.)

-L, --skip-line-numbers

Don't write line number forerrors.-n, --unbuffered Flush buffer after each query.

--column-names Write column names in results.

(Defaults to on; use --skip-column-names to disable.)

-N, --skip-column-names

Don't write column names in results.

--sigint-ignore Ignore SIGINT (CTRL-C).

-o, --one-database Ignore statements except those that occur while the

default database is the one named at the command line.

--pager[=name] Pager to use to display results. If you don't supply anoption, the default pager is taken fromyour ENV variable

PAGER. Valid pagers are less, more, cat[> filename],

etc. See interactive help (\h) also. Thisoption does not

work in batch mode. Disable with --disable-pager. This

option is disabled by default.-p, --password[=name]

Password to use when connecting to server. If password is

not given it's asked from the tty.

-P, --port=# 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).

--prompt=name Set the mysql prompt to this value.

--protocol=name The protocol to use for connection (tcp, socket, pipe,

memory).

-q, --quick Don't cache result, print it row byrow. This may slow

down the serverif the output is suspended. Doesn't use

history file.

-r, --raw Write fields without conversion. Used with --batch.

--reconnect Reconnect if the connection is lost. Disable with

--disable-reconnect. This option is enabled by default.

(Defaults to on; use --skip-reconnect to disable.)

-s, --silent Be more silent. Print results with a tab as separator,

each row on new line.

-S, --socket=name The socket file to use for connection.

--ssl Enable SSL for connection (automatically enabled with

other flags).

--ssl-ca=name CA file in PEM format (check OpenSSL docs, implies

--ssl).

--ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).

--ssl-cert=name X509 cert in PEM format (implies --ssl).

--ssl-cipher=name SSL cipher to use (implies --ssl).

--ssl-key=name X509 key in PEM format (implies --ssl).

--ssl-crl=name Certificate revocation list (implies --ssl).

--ssl-crlpath=name Certificate revocation list path (implies --ssl).

--ssl-verify-server-cert

Verify server's "Common Name" inits cert against

hostname usedwhen connecting. This option is disabled by

default.-t, --table Output in table format.

--tee=name 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.

-u, --user=name User for login if not current user.

-U, --safe-updates Only allow UPDATE and DELETE that uses keys.

-U, --i-am-a-dummy Synonym for option --safe-updates, -U.

-v, --verbose Write more. (-v -v -v gives the table output format).

-V, --version Output version information and exit.

-w, --wait Wait and retry if connection is down.

--connect-timeout=# Number of seconds before connection timeout.

--max-allowed-packet=#

The maximum packet length to send to or receive fromserver.--net-buffer-length=#

The buffer size for TCP/IP andsocket communication.--select-limit=# Automatic limit for SELECT when using --safe-updates.

--max-join-size=# Automatic limit for rows in a join when using

--safe-updates.

--secure-auth Refuse client connecting to server if it uses old

(pre-4.1.1) protocol.

(Defaultsto on; use --skip-secure-auth to disable.)

--server-arg=name Send embedded server this as a parameter.

--show-warnings Show warnings after every statement.

--plugin-dir=name Directory for client-side plugins.

--default-auth=name Default authentication client-side plugin to use.

--histignore=name A colon-separated list of patterns to keep statements

from getting logged intomysql history.--binary-mode By default, ASCII '\0' is disallowed and '\r\n' is

translated to '\n'. This switch turns offboth features,and also turns off parsing of all clientcommands except\Cand DELIMITER, in non-interactive mode (forinput

pipedto mysql or loaded using the 'source'command).

Thisis necessary when processing output frommysqlbinlog

that may contain blobs.--connect-expired-password

Notify the server that this client is prepared tohandle

expired password sandbox mode.Default options are read from the following files in the given order:/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

The following groups areread: mysql client

The following options may be givenasthe first argument:--print-defaults Print the program argument list and exit.--no-defaults Don't read default options from any option file,

except for login file.--defaults-file=# Only read default options from the given file #.--defaults-extra-file=# Read this file after the global files are read.--defaults-group-suffix=#

Also read groups with concat(group, suffix)--login-path=# Read this path from the login file.

Variables (--variable-name=value)

and boolean options {FALSE|TRUE} Value (after reading options)--------------------------------- ----------------------------------------

auto-rehash TRUE

auto-vertical-output FALSE

bind-address (No defaultvalue)character-sets-dir (No defaultvalue)column-type-info FALSE

comments FALSE

compress FALSE

debug-checkFALSE

debug-info FALSEdatabase (No defaultvalue)default-character-setauto

delimiter ;

enable-cleartext-plugin FALSE

vertical FALSE

force FALSE

named-commands FALSE

ignore-spaces FALSE

init-command (No defaultvalue)

local-infile FALSE

no-beep FALSE

host (Nodefaultvalue)

html FALSE

xml FALSE

line-numbers TRUE

unbuffered FALSEcolumn-names TRUE

sigint-ignore FALSE

port0prompt mysql>quick FALSErawFALSE

reconnect TRUE

socket (Nodefaultvalue)

ssl FALSE

ssl-ca (No defaultvalue)

ssl-capath (No defaultvalue)

ssl-cert (No defaultvalue)

ssl-cipher (No defaultvalue)

ssl-key (No defaultvalue)

ssl-crl (No defaultvalue)

ssl-crlpath (No defaultvalue)

ssl-verify-server-cert FALSEtableFALSEuser (No defaultvalue)

safe-updates FALSE

i-am-a-dummyFALSE

connect-timeout 0

max-allowed-packet 16777216net-buffer-length 16384

select-limit 1000

max-join-size 1000000secure-auth TRUE

show-warnings FALSE

plugin-dir (No defaultvalue)default-auth (No defaultvalue)

histignore (Nodefaultvalue)binary-mode FALSE

connect-expired-password FALSE