How To Install mysql-utilities on Ubuntu 18.04
Introduction
In this tutorial we learn how to install mysql-utilities on Ubuntu 18.04.
What is mysql-utilities
mysql-utilities is:
MySQL Utilities is both a set of command-line utilities as well as a Python library for making the common tasks easy to accomplish. The library is written entirely in Python, meaning that it is not necessary to have any other tools or libraries installed to make it work.
MySQL Utilities are intended to make working with servers easier. It is part of the MySQL Workbench.
This package provides the following utilities: mysqlauditadmin : maintain the audit log mysqlauditgrep : search an audit log mysqlbinlogmove : move binlog files to a different location mysqldbcompare : check two databases and identify any differences mysqldbcopy : copy databases from one MySQL server to another mysqldbexport : export a list of databases in a variety of formats mysqldbimport : import object definitions or data into a database mysqldiff : identify differences among database objects mysqldiskusage : show disk usage for one or more databases mysqlfabric : server farm management framework mysqlfailover : automatic replication health monitoring and failover mysqlfrm : show CREATE TABLE from .frm files mysqlgrants : privilege display utility mysqlindexcheck : check for redundant or duplicate indexes mysqlmetagrep : search MySQL servers for objects matching a pattern mysqlprocgrep : search MySQL servers for processes matching a pattern mysqlreplicate : setup replication among two MySQL servers mysqlrpladmin : administration utility for MySQL replication mysqlrplcheck : check prerequisities for replication mysqlrplms : establish a multi-source replication topology mysqlrplshow : show slaves attached to a master mysqlrplsync : check the data consistency between master and slaves mysqlserverclone : start a new instance of an existing MySQL server mysqlserverinfo : display common diagnostic information from a server mysqluc : command line client for running MySQL Utilities mysqluserclone : copy a MySQL user to new user(s) on another server
There are three methods to install mysql-utilities on Ubuntu 18.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install mysql-utilities Using apt-get
Update apt database with apt-get using the following command.
sudo apt-get update
After updating apt database, We can install mysql-utilities using apt-get by running the following command:
sudo apt-get -y install mysql-utilities
Install mysql-utilities Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install mysql-utilities using apt by running the following command:
sudo apt -y install mysql-utilities
Install mysql-utilities Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install mysql-utilities using aptitude by running the following command:
sudo aptitude -y install mysql-utilities
How To Uninstall mysql-utilities on Ubuntu 18.04
To uninstall only the mysql-utilities package we can use the following command:
sudo apt-get remove mysql-utilities
Uninstall mysql-utilities And Its Dependencies
To uninstall mysql-utilities and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:
sudo apt-get -y autoremove mysql-utilities
Remove mysql-utilities Configurations and Data
To remove mysql-utilities configuration and data from Ubuntu 18.04 we can use the following command:
sudo apt-get -y purge mysql-utilities
Remove mysql-utilities configuration, data, and all of its dependencies
We can use the following command to remove mysql-utilities configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge mysql-utilities
References
Summary
In this tutorial we learn how to install mysql-utilities package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.
