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

February 25, 2019

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

  • A sudo user.
  • An ITWeb.Services Ubuntu/Debian/Fedora/CentOS server instance.
  • 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!