MyCLI is a command line client for MySQL and MariaDB that allows you to auto-complete and helps with the syntax of your SQL commands.
Before installing any packages on the server instance, it is recommended that you update the system. Please review this article about How to Update CentOS 7, Ubuntu 16.04, and Debian 8.
On Debian/Ubuntu distributions, you can easily install the MyCLI package using the apt
command.
sudo apt-get install mycli
Fedora has a package available for MyCLI. Install it using dnf
command as shown below.
sudo dnf install mycli
For other Linux distributions such as RHEL/CentOS, you’ll need the Python Pip tool to install MyCLI.
Install Pip on your system.
sudo yum install python-pip
Once Pip has been installed, you can install MyCLI as follows.
sudo pip install mycli
Find your version of MyCLI and its usage using following two commands.
# mycli --version
Version: 1.10.0
# mycli --help
Usage: mycli [OPTIONS] [DATABASE]
A MySQL terminal client with auto-completion and syntax highlighting.
Examples:
- mycli my_database
- mycli -u my_user -h my_host.com my_database
- mycli mysql://my_user@my_host.com:3306/my_database
...
You could earn up to $300 by adding new articles