mycli - CLI for MySQL/MariaDB with auto-completion and syntax highlighting
Contents
Description
mycli is a command line interface for MySQL/MariaDB with auto-completion and syntax highlighting. It is
also capable of pretty printing tabular data.
Examples
$ mycli my_database
$ mycli -u my_user -h my_host.com my_database
$ mycli mysql://my_user@my_host.com:3306/my_database
Homepage
More information about mycli and the DBCLI project can be found on the homepage at https://www.mycli.net
and https://www.dbcli.com.
Name
mycli - CLI for MySQL/MariaDB with auto-completion and syntax highlighting
Options
-h|--host TEXT
Host address of the database.
-P|--port INTEGER
Port number to use for connection. Honors $MYSQL_TCP_PORT.
-u|--user TEXT
User name to connect to the database.
-S|--socket TEXT
The socket file to use for connection.
-p|--password|--pass TEXT
Password to connect to the database.
-v|--version
Version of mycli.
-D|--database TEXT
Database to use.
-R|--prompt TEXT
Prompt format (Default: "\t \u@\h:\d> ").
-l|--logfile FILENAME
Log every query and its results to a file.
--defaults-group-suffix TEXT
Read config group with the specified suffix.
--defaults-file PATH
Only read default options from the given file.
--login-path TEXT
Read this path from the login file.
--help
Shows the help message and exit.
See Also
litecli(1) pgcli(1) iredis(1)
Synopsis
mycli [OPTIONS] [DATABASE]
