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