How To Install phpmyadmin on Ubuntu

Posted on April 1, 2023 (Last modified on May 20, 2023 )

3 minutes • 528 words

Introduction

In this tutorial we learn how to install phpmyadmin on Ubuntu.

What is `phpmyadmin`

phpmyadmin is:

This package allows administering of MySQL or MariaDB with a web interface.

It allows administrators to:

browse through databases and tables;
create, copy, rename, alter and drop databases;
create, copy, rename, alter and drop tables;
perform table maintenance;
add, edit and drop fields;
execute any SQL-statement, even multiple queries;
create, alter and drop indexes;
load text files into tables;
create and read dumps of tables or databases;
export data to SQL, CSV, XML, Word, Excel, PDF and LaTeX formats;
administer multiple servers;
manage MySQL users and privileges;
check server settings and runtime information with configuration hints;
check referential integrity in MyISAM tables;
create complex queries using Query-by-example (QBE), automatically connecting required tables;
create PDF graphics of database layout;
search globally in a database or a subset of it;
transform stored data into any format using a set of predefined functions, such as displaying BLOB-data as image or download-link;
manage InnoDB tables and foreign keys; and is fully internationalized and localized in dozens of languages.

There are three methods to install phpmyadmin on Ubuntu. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install phpmyadmin Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install phpmyadmin using apt-get by running the following command:

sudo apt-get -y install phpmyadmin

Install phpmyadmin Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install phpmyadmin using apt by running the following command:

sudo apt -y install phpmyadmin

Install phpmyadmin 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 phpmyadmin using aptitude by running the following command:

sudo aptitude -y install phpmyadmin

How To Uninstall phpmyadmin on Ubuntu

To uninstall only the phpmyadmin package we can use the following command:

sudo apt-get remove phpmyadmin

Uninstall phpmyadmin And Its Dependencies

To uninstall phpmyadmin and its dependencies that are no longer needed by Ubuntu, we can use the command below:

sudo apt-get -y autoremove phpmyadmin

Remove phpmyadmin Configurations and Data

To remove phpmyadmin configuration and data from Ubuntu we can use the following command:

sudo apt-get -y purge phpmyadmin

Remove phpmyadmin configuration, data, and all of its dependencies

We can use the following command to remove phpmyadmin configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge phpmyadmin

Dependencies

phpmyadmin have the following dependencies:

References

phpmyadmin website

Summary

In this tutorial we learn how to install phpmyadmin package on Ubuntu using different package management tools: apt, apt-get and aptitude.