MySQL, mysql命令注释

/opt/mysql/bin/mysql-B, --batch Don't use history file. Disable interactive behavior.(Enables --silent.)--bind-address=name IP address to bind to. 绑定IP地址--character-sets-dir=name Directory for character set files. 字符集设定文件，一般不用指定，直接放在my.cnf里面--column-type-infoDisplay column type information. 列出列属性-D, --database=name Database to use. 指定连接时数据库--default-character-set=name Set the default character set. 设定启动SESSION的字符集--delimiter=nameDelimiter to be used.--enable-cleartext-plugin Enable/disable the clear text authentication plugin.-e, --execute=nameExecute command and quit. (Disables --force and history 命令行中执行SQL语句file.)-E, --verticalPrint 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'sinternal commands; see mysql> help . When enabled, thenamed 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 isdisabled 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.启动时自动执行SQL语句，可以用来指定一些SESSION参数，比如set names--local-infileEnable/disable LOAD DATA LOCAL INFILE.-h, --host=name Connect to host.--column-namesWrite column names in results.(Defaults to on; use --skip-column-names to disable.)列出查询语句返回表头，用-N可以忽略表头-N, --skip-column-names Don't write column names in results.--sigint-ignore Ignore SIGINT (CTRL-C).-o, --one-databaseIgnore statements except those that occur while the default database is the one named at the command line. 指定连接数据库，在恢复的时候比较好用。不知道和-D的差异在哪里。--pager[=name]Pager to use to display results. If you don't supply anoption, the default pager is taken from your ENV variablePAGER. Valid pagers are less, more, cat [> filename],etc. See interactive help (\h) also. This option does notwork in batch mode. Disable with --disable-pager. Thisoption is disabled by default.-p, --password[=name] Password to use when connecting to server. If password isnot given it's asked from the tty.-P, --port=#Port number to use for connection or 0 for default to, inorder of preference, my.cnf, $MYSQL_TCP_PORT,/etc/services, built-in default (3306).指定端口号，一般和 --protocol一起使用。--prompt=name Set the mysql prompt to this value.--protocol=name The protocol to use for connection (tcp, socket, pipe,memory).指定连接协议，一般和-P一起使用-s, --silentBe 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 withother 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=nameX509 key in PEM format (implies --ssl).--ssl-crl=nameCertificate revocation list (implies --ssl).--ssl-crlpath=nameCertificate revocation list path (implies --ssl).--ssl-verify-server-cert Verify server's "Common Name" in its cert againsthostname used when connecting. This option is disabled bydefault.--ssl-mode=name SSL connection mode.-t, --table Output in table format.--tee=nameAppend everything into outfile. See interactive help (\h)also. Does not work in batch mode. Disable with--disable-tee. This option is disabled by default. 同LINUX命令tee-u, --user=name User for login if not current user.-U, --safe-updatesOnly allow UPDATE and DELETE that uses keys.-U, --i-am-a-dummySynonym 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, --waitWait 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 and socket 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.(Defaults to 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 statementsfrom getting logged into mysql history.--binary-mode By default, ASCII '\0' is disallowed and '\r\n' istranslated 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 inputpiped to mysql or loaded using the 'source' command).This is necessary when processing output from mysqlbinlogthat may contain blobs.--connect-expired-password Notify the server that this client is prepared to handleexpired password sandbox mode.Default options are read from the following files in the given order:/etc/my.cnf /etc/mysql/my.cnf /opt/mysql/etc/my.cnf ~/.my.cnf The following groups are read: mysql clientThe following options may be given as the first argument:--print-defaultsPrint 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.