How to install phpmyadmin on Linux (Ubuntu)
Tags: opensource, howto, linux
Published: 2018-02-06 14:24:15

---
title: "How to install phpmyadmin on Linux (Ubuntu)"
published: true
tags: FOSS,HowTo,Linux,open source
canonical_url: https://fossnaija.com/install-phpmyadmin-linux-ubuntu/
---

[![phpmyadmin_fossnaija](https://i0.wp.com/fossnaija.com/wp-content/uploads/2017/08/phpmyadmin.png?resize=665%2C349&ssl=1)](https://i0.wp.com/fossnaija.com/wp-content/uploads/2017/08/phpmyadmin.png?ssl=1)

The MySQL database server can be administered using the command line, by running commands in the terminal. But it is more convenient and less tedious to use a graphical user interface (phpmyadmin) – most especially for those who are not comfortable with entering commands on a terminal.

phpMyAdmin is a free and open source GUI software tool written in <u><a href="https://php.net/"><span style="font-family: 'Quattrocento Sans', serif;"><span style="font-size: large;">PHP</span></span></a></u>, intended to handle the administration of <u><a href="https://www.mysql.com/"><span style="font-family: 'Quattrocento Sans', serif;"><span style="font-size: large;">MySQL</span></span></a></u> over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.

Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement. And also perform exporting and importation of data in popular file formats (CSV, SQL, XML, PDF, Word, Excel, LaTeX and many others). phpMyAdmin is cross-platform and one of the most popular MySQL administration tool.

In this post, we’d be installing it on a Linux operating system. But before we begin ensure that you have Apache, MySQL and PHP install on your system. If not [do it here.](https://dev.to/xeroxism/how-to-install-lamp-server-in-linux-ubuntu-3pg-temp-slug-5992026)

## 

## Install phpMyAdmin.

Using the Ubuntu package manager apt (you can use other package managers for the respective Linux distributions), open th the terminal.

**sudo apt-get install phpmyadmin**

Then installation begins. When prompted, select “Apache2” from the “Configuring phpMyAdmin” dialogue box. When asked for MySQL username and password enter “_root_” for username and _YOUR\_MYSQL\_PASSWORD_ for password.

After installation is complete, configure phpMyAdmin to be recognised by the local web server.

Open the apache configuration file in your favourite text editor;

**sudo gedit /etc/apache2/apache2.conf**

and add the following line at the bottom of the file (you can add it anywhere in the file, I just choose the bottom here so that you can easily access it for modification):

_Include /etc/phpmyadmin/apache.conf_

then restart the web server;

**sudo service apache2 restart**

Now enter the following url in your browser;

<u><a href="https://localhost/phpmyadmin"><span style="font-family: 'Quattrocento Sans', serif;"><span style="font-size: large;"><i>https://localhost/phpmyadmin</i></span></span></a></u>

You should see a login page for you to enter your username and password, if you’ve not done so.

Username = root

password = YOUR\_MYSQL\_PASSWORD

[![phpmyadmin_login_fossnaija](https://i2.wp.com/fossnaija.com/wp-content/uploads/2017/08/PMA-e1501723966144-1024x501.png?resize=665%2C325&ssl=1)](https://i2.wp.com/fossnaija.com/wp-content/uploads/2017/08/PMA-e1501723966144.png?ssl=1)

IMAGE: FOSSNAIJA.COM

If successful the phpMyAdmin dashboard appears:

[![phpmyadmin_homepage_fossnaija](https://i1.wp.com/fossnaija.com/wp-content/uploads/2017/08/PMA-homepage-e1501724058455-1024x559.png?resize=665%2C363&ssl=1)](https://i0.wp.com/fossnaija.com/wp-content/uploads/2017/08/PMA-homepage-e1501724058455.png?ssl=1)

phpmyadmin web homepage.

_Congrats!_

_ **Happy Linux’NG!** _

The post [How to install phpmyadmin on Linux (Ubuntu)](https://fossnaija.com/install-phpmyadmin-linux-ubuntu/) appeared first on [Foss Naija](https://fossnaija.com).