MyCLI is an easy-to-use command line interface (CLI) for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting to help speed up your development.
The MyCLI tool is based on Python and must be installed via PIP. Make sure you have the pip and python development libraries installed. With the ECS instance set up correctly, all you have to do is run the following three lines of code to install MyCLI.
yum install python-pip
yum -y install python-devel
pip install mycli
If you don't know how to use MyCLI, you can always run the —help command to find out about its various options, as shown below.
$ 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.
Simply run the following command to run MyCLI on your ApsaraDB for RDS instance.
$ mycli ®Ch{RDS DNS Alias} ®Cu{RDS User Name} -p{RDS Password}
Once connected, you can use MyCLI in the same way you would use the default CLI.
Alibaba Cloud also provides its own command auto-completion function on Alibaba Cloud CLI. For more information, please visit https://www.alibabacloud.com/help/doc-detail/29998.html Please give me.