mycli1
Cli for mysql/mariadb with auto-completion and syntax highlighting
Usage
mycli [OPTIONS]
[DATABASE]
Overview
mycli is a command line interface for MySQL/MariaDB with auto-completion and syntax highlighting. It is also capable of pretty printing tabular data.
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.
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.
Releases
5 releases since Debian 9 (Stretch); the text changed 1 time.