MyCLI is a command-line client for MySQL and MariaDB, offering autocomplete features as users compose SQL statements.

The primary features of MyCLI include:

• Autocomplete for SQL keywords, and also suggests table names, view names, and column names as you type.
• Syntax highlighting.
• Supports multi-line statements.
• Capability to save frequently used statements.
• Displays table data in a more aesthetically pleasing format.
• Supports SSL connections.
• Generates log files daily.

Installing MyCLI

MyCLI can be installed on various versions of Linux cloud servers.

Debian/Ubuntu：

sudo apt-get install mycli

CentOS：

sudo yum install python-pip

sudo pip install mycli

Fedora：

sudo dnf install mycli

Other Common Commands

To check the MyCLI version:

# mycli --version 
Version: 1.10.0

To view MyCLI help:

# mycli --help
Usage: mycli [OPTIONS] [DATABASE]