Command line interface for utilities mycli:MySQL, MariaDB, and Percona

Mycli is a modern alternative to the default MySQL client, and mycli will automatically complete keywords, table names, columns, and functions as you type.

HomePage: http://mycli.net

The results are as follows:

RHEL, Centos installation method:

Currently, the author does not provide a RPM package for RHEL and Centos. For the time being, you can install it using pip:

$sudo yum install python-pip

$sudo git clone https://github.com/dbcli/mycli

$sudo pip install mycli

Command to use help:

$mycli-help

Usage: mycli [OPTIONS] [DATABASE]

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 TEXT Password to connect to the database

-- pass TEXT Password to connect to the database

-- ssl-ca PATH CA file in PEM format

-- ssl-capath TEXT 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

Ssl-verify-server-cert Verify server's "Common Name" in its cert

Against hostname used when connecting. This

Option is disabled by default

-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

-- myclirc PATH Location of myclirc file.

-- auto-vertical-output Automatically switch to vertical output mode

If the result is wider than the terminal

Width.

-t,-- table Display batch output in table format.

-- csv Display batch output in CSV format.

-warn /-- no-warn Warn before running a destructive query.

-- local-infile BOOLEAN Enable/disable LOAD DATA LOCAL INFILE.

-- login-path TEXT Read this path from the login file.

-e,-- execute TEXT Execute query to the database.

-- help Show this message and exit.

Examples of use:

$mycli local_database

$mycli-h localhost-u root app_db

$mycli mysql://amjith@localhost:3306/django_poll

Error resolution:

The following error occurs:

Error: command 'gcc' failed with exit status 1

Indicates that the dependency package is not fully installed, and the solution:

$sudo yum install python-devel mysql-devel zlib-devel openssl-devel