For the popular database servers like MySQL, MariaDB and Percona, you have to run different commands for the task like displaying the database, showing tables, listing users from tables and so on. With MyCLI, running such commands is easy.
MyCLI is basically a command line interface (CLI) built using prompt_toolkit library and Python which provides syntax highlighting and auto-completion.
You can also configure MyCLI for the listing of previous commands with the up/down arrow key. So you don't need to worry about typing the previous commands again.
Here at LinuxAPT, as part of our Server Management Services, we regularly help our Customers to perform related Linux System Database queries.
In this context, we shall look into how to install and use MyCLI on Ubuntu 20.04 server.
To install MyCLI on Ubuntu 20.04 LTS server, you can run the below commands:
$ sudo apt update
$ sudo apt install mycli -y
With the above command, mycli will be completely installed and ready to use.
Here, we are going to use the MyCLI command for the popular database server MySQL. Lets run a few commands by using MyCLI features which makes it easy to run commands and syntax:
# mycli -u root -p database_name
Here, you will see the options to complete the syntax which makes it easy to choose one of the required ones.
With the MyCLI auto-completions feature, you can see the options to complete the syntax just by typing SELECT * F. This will display the options like FROM which makes it easy to choose one of the required ones.
# mycli -u root -p phpmyadmin
SELECT * F
The smart completions feature of MyCLI goes like this:
SELECT * FROM pma__table_info WHERE
Here, we have pressed space after WHERE, it is showing options for related tables. In our case, it is showing column options for table pma__table__info.
This feature is also useful Even after the table names are aliased, column completions will work as illustrated below:
SELECT * FROM pma__table_info WHERE db_name;
SELECT t FROM pma__table_info WHERE db_name;
This article covers how to install and use the MyCLI tool on your Ubuntu Linux system. In fact, MyCLI is an easy-to-use command line interface (CLI) for MySQL, MariaDB, and Percona, that helps you speed up development with auto-completion and syntax highlighting features.
How to install the MyCLI tool on your Linux system ?
MyCLI tool is based on Python and needs to be installed via pip. Make sure PIP and python development libraries are installed.:
$ yum install python-pip
$ yum -y install python-devel
$ pip install mycli
MyCLI Features include: