客户端连接参数
参数名称 | 描述 | 是否符合预期 | 验证版本 |
---|---|---|---|
--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 |
文档内容是否有帮助?