$ pip install --upgrade 'mycli[all]'

$ brew update && brew install mycli fzf pygments

$ mycli --help
Usage: mycli [OPTIONS] [DATABASE]

  A MySQL terminal client with auto-completion and syntax highlighting.

  Examples:
    - mycli my_database
    - mycli -u my_user -h my_host.com my_database
    - mycli mysql://my_user@my_host.com:3306/my_database

Options:
  -h, --host, --hostname TEXT     Host address of the database.
  -P, --port INTEGER              Port number to use for connection. Honors
                                  $MYSQL_TCP_PORT.
  -u, --user, --username TEXT     User name to connect to the database.
  -S, --socket TEXT               The socket file to use for connection.
  -p, --pass, --password TEXT     Password to connect to the database. Use
                                  with a value to set the password at the CLI,
                                  or alone in the last position to request a
                                  prompt.
  --password-file PATH            File or FIFO path containing the password to
                                  connect to the db if not specified
                                  otherwise.
  --ssl-mode [auto|on|off]        Set desired SSL behavior. auto=preferred if
                                  TCP/IP, on=required, off=off.
  --ssl-ca PATH                   CA file in PEM format.
  --ssl-capath DIRECTORY          CA directory.
  --ssl-cert PATH                 X509 cert in PEM format.
  --ssl-key PATH                  X509 key in PEM format.
  --ssl-cipher TEXT               SSL cipher to use.
  --tls-version [tlsv1|tlsv1.1|tlsv1.2|tlsv1.3]
                                  TLS protocol version for secure connection.
  --ssl-verify-server-cert        Verify server's "Common Name" in its cert
                                  against hostname used when connecting. This
                                  option is disabled by default.
  -v, --verbose                   More verbose output and feedback.  Can be
                                  given multiple times.
  -q, --quiet                     Less verbose output and feedback.
  -D, --database TEXT             Database or DSN to use for the connection.
  -d, --dsn TEXT                  DSN alias configured in the ~/.myclirc file,
                                  or a full DSN.
  --list-dsn                      Show list of DSN aliases configured in the
                                  [alias_dsn] section of ~/.myclirc.
  -R, --prompt TEXT               Prompt format (Default: "\t \u@\h:\d> ").
  --toolbar TEXT                  Toolbar format.
  -l, --logfile FILENAME          Log every query and its results to a file.
  --checkpoint TEXT               In batch or --execute mode, log successful
                                  queries to a file, and skip them with
                                  --resume.
  --resume                        In batch mode, resume after replaying
                                  statements in the --checkpoint file.
  --myclirc PATH                  Location of myclirc file.
  --auto-vertical-output          Automatically switch to vertical output mode
                                  if the result is wider than the terminal
                                  width.
  --show-warnings / --no-show-warnings
                                  Automatically show warnings after executing
                                  a SQL statement.
  -t, --table                     Shorthand for --format=table.
  --csv                           Shorthand for --format=csv.
  --warn / --no-warn              Warn before running a destructive query.
  --warn-batch                    Warn before running a destructive query when
                                  executing a script.
  --local-infile BOOLEAN          Enable/disable LOAD DATA LOCAL INFILE.
  -g, --login-path TEXT           Read this path from the login file.
  -e, --execute TEXT              Execute command and quit.
  --init-command TEXT             SQL statement to execute after connecting.
  --unbuffered                    Instead of copying every row of data into a
                                  buffer, fetch rows as needed, to save
                                  memory.
  --charset, --character-set TEXT
                                  Character set for MySQL session.
  --batch TEXT                    SQL script to execute in batch mode.
  --format [default|csv|tsv|table]
                                  Format for batch or --execute output.
  --throttle FLOAT                Pause in seconds between queries in batch
                                  mode.
  --progress                      Show progress on the standard error with
                                  --batch.
  --use-keyring [true|false|reset]
                                  Store and retrieve passwords from the system
                                  keyring: true/false/reset.
  --keepalive-ticks INTEGER       Send regular keepalive pings to the
                                  connection, roughly every <int> seconds.
  --checkup                       Run a checkup on your configuration.
  -V, --version                   Output mycli's version.
  --help                          Show this message and exit.