How to install PHPMyAdmin on Ubuntu

On previous article i already show you how to install apache, php and also mysql database on ubuntu, and now you probably needing phpmyadmin as user interface for managing mysql database.

Without phpmyadmin you will be stuck with command line to manage your databases, having phpmyadmin will makes your work a lot easier.

You can create new databases, create new tables, modify tables, insert edit and delete data, etc using phpmyadmin, of course it also depends on what user you are using to login on mysql.

Alright enough talking, let's start install phpmyadmin on our ubuntu, open up terminal/console/command line and then run this command to install phpmyadmin.

sudo apt-get install phpmyadmin

You will be asked 'web server to reconfigure automatically?' choose 'apache2'. And then another questions 'configure database for phpmyadmin with dbconfig-common?' choose 'yes'.

When you choose 'yes', you will be asking for password of mysql database, make sure you enter the correct password for mysql database (user root).

Next step, we need to tell apache web server where is the location of phpmyadmin, we need to edit apache2 configuration file (/etc/apache2/apache2.conf).

sudo gedit /etc/apache2/apache2.conf

You need to add these code at the end of the apache2 config file, so that apache web server could recognize phpmyadmin.

Include /etc/phpmyadmin/apache.conf

You need to restart apache web server in order the changes to take effect, go ahead run sudo service apache2 restart.

sudo service apache2 restart

Finally you can try opening the phpmyadmin, the url is http://localhost/phpmyadmin/, you will be asked to enter username and password of mysql database.