How to Install MyCLI on Linux (CentOS, Debian, Fedora, and Ubuntu)

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 #

  • A sudo user.
  • A Ubuntu/Debian/Fedora/CentOS server instance.

Before installing any packages on the server instance, it is recommended that you update the system.

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://[email protected]_host.com:3306/my_database
...

Powered by BetterDocs

Privacy Preference Center

      Necessary

      Advertising

      Analytics

      Other