Utility Mycli:mysql, MariaDB, and Percona command-line interface

MYCLI is a modern alternative to the default MySQL client, and MYCLI automatically complements the keywords, table names, columns, and functions as you type.

Homepage:http://mycli.net

Use the effect as follows:

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/96/7B/wKiom1kicZ6jgflXAAIAWLEBjs0884.gif "title=" Main.gif "alt=" Wkiom1kicz6jgflxaaiawlebjs0884.gif "/>

RHEL, CentOS installation method:

Currently the author does not provide RPM packages for Rhel, CentOS, and can be temporarily installed with PIP mode:

$ sudo yum install Python-pip

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

$ sudo pip install Mycli

Command 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 \[email protected]\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://[email Protected]:3306/django_poll

Error Resolution:

The following error occurred:

Error:command ' gcc ' failed with exit status 1

Indicates that there is a dependency package is not installed, the solution:

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

Reference Link: Https://github.com/dbcli/mycli#rhel-centos

Utility Mycli:mysql, MariaDB, and Percona command-line interface