| MYCLI(1) | DBCLI | MYCLI(1) |
NAME¶
mycli - CLI for MySQL/MariaDB with auto-completion and syntax highlighting
SYNOPSIS¶
mycli [OPTIONS] [DATABASE]
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.
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
SEE ALSO¶
litecli(1)
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.
AUTHORS¶
mycli was written by Amjith Ramanujam <amjith.r@gmail.com>.
| 2.23.2 | mycli |