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

Source: Internet
Author: User
Tags mysql client x509 cert percona git clone

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.