Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report