MyCLI is a command line interface for MySQL, MariaDB and Percona with autocomplete and syntax highlighting. This tool will help you a lot with the syntax of your SQL commands. Some very useful features of MyCli: Autocomplete when entering SQL keywords, as well as tables, views and columns in the database, support for multi-line queries, easy printing of tabular data, syntax highlighting for input when typing, and also support for SSL connections.
Installation
In order to install MyCLi, you need to run the following command (Installation focuses on Debian & Ubuntu, all versions):
apt-get install mycli
With the help of the following command, which is described below, it is possible to install MyCLi for CentOS (first install pip):
yum install python-pip
After that, enter this command:
pip install mycli
With the following command, which is described below, it is possible to install MyCLi for Fedora
dnf install mycli
You can check the installation and find the version of MyCLi using the following commands:
mycli --version
mycli --help
Leave A Comment?