Learn How To Install MyCLI on Linux (CentOS, Debian, Fedora, and Ubuntu)
Table of Contents
Introduction
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.
MyCLI Features
- Auto-completion as you type for SQL keywords as well as tables, views, and columns in the database.
- Syntax highlighting of input while typing.
- Support for multiline queries.
- Allows you to save your favorite queries.
- Prints tabular data in an appealing way.
- Support for SSL connections.
- Smart-completion (enabled by default) will suggest context-sensitive completion.
- Log every query and its results to a file.
Requirements
https://www.itweb.services/tutorials/linux-guides/how-to-update-centos-7-ubuntu-16-04-and-debian-8″>How to Update CentOS 7, Ubuntu 16.04, and Debian 8.
Installation
Debian/Ubuntu
On Debian/Ubuntu distributions, you can easily install the MyCLI package using the apt
command.
sudo apt-get install mycli
Fedora
Fedora has a package available for MyCLI. Install it using dnf
command as shown below.
sudo dnf install mycli
RHEL, CentOS
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
...
Need help?
Do you need help setting up this on your own service?
Please contact us and we’ll provide you the best possible quote!