官网

https://www.mycli.net

下载

pip install mycli

用法

  1. # mycli --help
  3. Usage: mycli [OPTIONS] [DATABASE]
  5.   A MySQL terminal client with auto-completion and syntax highlighting.
  7.   Examples:
  8.     - mycli my_database
  9.     - mycli -u my_user -h my_host.com my_database
  10.     - mycli mysql://my_user@my_host.com:3306/my_database
  12. Options:
  13.   -h, --host TEXT               Host address of the database.
  14.   -P, --port INTEGER            Port number to use for connection. Honors
  15.                                 $MYSQL_TCP_PORT.
  17.   -u, --user TEXT               User name to connect to the database.
  18.   -S, --socket TEXT             The socket file to use for connection.
  19.   -p, --password TEXT           Password to connect to the database.
  20.   --pass TEXT                   Password to connect to the database.
  21.   --ssh-user TEXT               User name to connect to ssh server.
  22.   --ssh-host TEXT               Host name to connect to ssh server.
  23.   --ssh-port INTEGER            Port to connect to ssh server.
  24.   --ssh-password TEXT           Password to connect to ssh server.
  25.   --ssh-key-filename TEXT       Private key filename (identify file) for the
  26.                                 ssh connection.
  28.   --ssh-config-path TEXT        Path to ssh configuration.
  29.   --ssh-config-host TEXT        Host to connect to ssh server reading from ssh
  30.                                 configuration.
  32.   --ssl-ca PATH                 CA file in PEM format.
  33.   --ssl-capath TEXT             CA directory.
  34.   --ssl-cert PATH               X509 cert in PEM format.
  35.   --ssl-key PATH                X509 key in PEM format.
  36.   --ssl-cipher TEXT             SSL cipher to use.
  37.   --ssl-verify-server-cert      Verify server's "Common Name" in its cert
  38.                                 against hostname used when connecting. This
  39.                                 option is disabled by default.
  41.   -V, --version                 Output mycli's version.
  42.   -v, --verbose                 Verbose output.
  43.   -D, --database TEXT           Database to use.
  44.   -d, --dsn TEXT                Use DSN configured into the [alias_dsn]
  45.                                 section of myclirc file.
  47.   --list-dsn                    list of DSN configured into the [alias_dsn]
  48.                                 section of myclirc file.
  50.   --list-ssh-config             list ssh configurations in the ssh config
  51.                                 (requires paramiko).
  53.   -R, --prompt TEXT             Prompt format (Default: "\t \u@\h:\d> ").
  54.   -l, --logfile FILENAME        Log every query and its results to a file.
  55.   --defaults-group-suffix TEXT  Read MySQL config groups with the specified
  56.                                 suffix.
  58.   --defaults-file PATH          Only read MySQL options from the given file.
  59.   --myclirc PATH                Location of myclirc file.
  60.   --auto-vertical-output        Automatically switch to vertical output mode
  61.                                 if the result is wider than the terminal
  62.                                 width.
  64.   -t, --table                   Display batch output in table format.
  65.   --csv                         Display batch output in CSV format.
  66.   --warn / --no-warn            Warn before running a destructive query.
  67.   --local-infile BOOLEAN        Enable/disable LOAD DATA LOCAL INFILE.
  68.   --login-path TEXT             Read this path from the login file.
  69.   -e, --execute TEXT            Execute command and quit.
  70.   --help                        Show this message and exit.

配置

  • C:\Users\<username>\.myclirc 用户配置
  • C:\Users\<username>\.my.cnf 客户端配置