How To Install & Configure phpMyAdmin On Ubuntu 12.04 & Greater Versions?

phpMyAdmin is a free software that provides you a user friendly interface to work with MySQL on the web. It simply provides you a convenient visual frontend to access MySQL capabilities. This tutorial shows you the steps for installing phpMyAdmin on Ubunu Linux so before installing it make sure you must have root privileges on your virtual private server.

apt-get is the easiest way of installing phpMyAdmin on Linux. Open your terminal and give the following command:

sudo apt-get install phpmyadmin

During the installation, phpMyAdmin will ask you a few questions for configuration:

phpmyadmin2

    • It asks yous to choose server, select Apache2 for the server:phpmyadmin1
    • Next select YES when it asks you to configure database for phpmyadmin using dbconfig-common: phpmyadmin3
    • When it prompts you will have to enter your MySQL password
    • Now enter password that you want to use for logfing into  phpmyadm
    • Re-type and confirm the password

After installation completes, add phpmyadmin to apache configuration via following command:

sudo nano /etc/apache2/apache2.conf

Scroll down the cursor and add the phpmyadmin config to file by copy-pasting the following line:

Include /etc/phpmyadmin/apache.conf

php-apache

Restart apache by following command in terminal:

sudo service apache2 restart

Now you can access phpmyadmin by opening youraddress/phpmyadmin

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.