mycli
Mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.
- Source: https://github.com/dbcli/mycli
- Chat: Gitter
- Mailing List: https://groups.google.com/forum/#!forum/mycli-users
Quick Start
If you already know how to install python packages, then you can simply do:
$ pip install mycli
If you're on OS X you can install it via homebrew.
$ brew install mycli
If you're having trouble with the quick start, check the install page for detailed instructions.
Usage
$ mycli --help
Usage: mycli [OPTIONS] [DATABASE]
Options:
-h, --host TEXT Host address of the database.
-P, --port TEXT 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 Force password prompt.
--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.
--help Show this message and exit.
Examples
$ mycli local_database
$ mycli -h localhost -u root app_db
$ mycli mysql://amjith@localhost:3306/django_poll