Install Phpmyadmin on Ubuntu

Date Posted:23-05-2017

Phpmyadmin is a opensource php application to manage database through web browser. We can create database, users, manage database tables, granting privileges and much more operation through browsers. We will explain on how to install phpmyadmin on Ubuntu host.

Prerequisites:

  1. This post assumes that Ubuntu is running on the machine. This was tested on Ubuntu 16.04 and we can follow the same procedure for ubuntu 14 and ubuntu 17 version as well.
  2. WebServer- Apache 2. Incase apache is not installed, follow the below post to install apache2 on ubuntu host.

Install Apache2 on Ubuntu Host

Implementation:

Install Phpmyadmin using apt-get utility.

apt-get install phpmyadmin

This command will download and install phpmyadmin application along with its dependencies. The below are normal dependency packages will be installed along with phpmyadmin.

php-mbstring
php-mcrypt
php-gd
php-xml

Press ‘y’ to continue the installation.

Next, it will ask to select the webserver. Select ‘Apache’ and continue the installation.

It will prompt to enter Yes or no for ‘Configuring phpmyadmin, db-common config’. Just press enter to continue the installation.

The following files will be created on apache2 directory automatically at the end of installation incase of ubuntu 16 server.

/etc/apache2/conf-available/phpmyadmin.conf

The following symlink will also be created.
 /etc/apache2/conf-available/phpmyadmin.conf -> /etc/phpmyadmin/apache.conf

/etc/apache2/conf-enabled/phpmyadmin.conf -> /etc/apache2/conf-available/phpmyadmin.conf

Restart the webserver.

systemctl restart apache2

Access the IP address or hostname on the browser to get phpmyadmin page.

http://IPADDRESS/phpmyadmin

Leave a Reply