How to install MySQL CLI (mycli) on Linux

November 24, 2021

Try VPSie
40% OFF Free A Month Fastest Amazing Super
Cloud Service

How to install MySQL CLI (mycli) on Linux

The mycli command-line interface provides autocompletion and syntax highlighting for MariaDB, MySQL, and Percona support. Throughout this tutorial, we’ll show you how to set up MySQL CLI on Linux. Our discussion will cover the installation of mycli on Ubuntu, Debian, CentOS, RHEL, and Fedora.

MySQL, MariaDB, and Percona are all supported by mycli, along with the following features:

Automatically completes commands, and cases sensitively, as soon as we begin typing.
Prints tabular data in an attractive manner.
SSL connection support.
Highlighting of syntax.
Multi-theme support.
It is able to handle Unicode input and output.

So let’s start the installation,

Step 1: Set up a VPSie cloud server

Start by logging into your VPSie account Make a new server, There are several Linux distributions available on vpsie and after creating one use the credentials that we emailed you to connect to your Cloud Server via SSH.

Step 2: Install MySQL CLI – mycli

Mycli packages are available for Debian/Ubuntu and Fedora within their respective system package manager repositories, using the following commands to install them,

Debian/Ubuntu

# sudo apt-get install mycli

Fedora

# sudo dnf install mycli

RedHat & CentOS do not have rpm packages, and we will need to use pip to do so. Installing mycli with pip is possible on Ubuntu, Fedora, or CentOS/RHEL.

RHEL/CentOS

Install Pip on your system by running the following command.

# sudo yum install python-pip

After installing Pip, follow these instructions to install MyCLI.

# sudo pip install mycli

Use the following command to find your MyCLI version.Use the following command to find your MyCLI version,

# mycli --version
Version: 1.20.1

To learn more, roam around. Enter this command,

  # mycli --help

  Usage: mycli [OPTIONS] [DATABASE]

  A MySQL terminal client with auto-completion and syntax highlighting.

Options:
  -h, --host TEXT               Host address of the database.
  -P, --port INTEGER            Port number to use for connection. Honors
                                $MYSQL_TCP_PORT.
  -u, --user TEXT               User name to connect to the database.
  -S, --socket TEXT             The socket file to use for connection.
  -p, --password TEXT           Password to connect to the database.
  --pass TEXT                   Password to connect to the database.
  --ssh-user TEXT               User name to connect to ssh server.
  --ssh-host TEXT               Host name to connect to ssh server.
  --ssh-port INTEGER            Port to connect to ssh server.
  --ssh-password TEXT           Password to connect to ssh server.
  --ssh-key-filename TEXT       Private key filename (identify file) for the
                                ssh connection.
  --ssl-ca PATH                 CA file in PEM format.
  --ssl-capath TEXT             CA directory.
  --ssl-cert PATH               X509 cert in PEM format.
  --ssl-key PATH                X509 key in PEM format.
  --ssl-cipher TEXT             SSL cipher to use.
  --ssl-verify-server-cert      Verify server's "Common Name" in its cert
                                against hostname used when connecting. This
                                option is disabled by default.
  -V, --version                 Output mycli's version.
  -v, --verbose                 Verbose output.
  -D, --database TEXT           Database to use.
  -d, --dsn TEXT                Use DSN configured into the [alias_dsn]
                                section of myclirc file.
  --list-dsn                    list of DSN configured into the [alias_dsn]
                                section of myclirc file.
  -R, --prompt TEXT             Prompt format (Default: "\t \[email protected]\h:\d> ").
  -l, --logfile FILENAME        Log every query and its results to a file.
  --defaults-group-suffix TEXT  Read MySQL config groups with the specified
                                suffix.
  --defaults-file PATH          Only read MySQL options from the given file.
  --myclirc PATH                Location of myclirc file.
  --auto-vertical-output        Automatically switch to vertical output mode
                                if the result is wider than the terminal
                                width.
  -t, --table                   Display batch output in table format.
  --csv                         Display batch output in CSV format.
  --warn / --no-warn            Warn before running a destructive query.
  --local-infile BOOLEAN        Enable/disable LOAD DATA LOCAL INFILE.
  --login-path TEXT             Read this path from the login file.
  -e, --execute TEXT            Execute command and quit.
  --help                        Show this message and exit.