How to install phpmyadmin on ubuntu 12.04

Phpmyadmin on ubuntu :

Phpmyadmin is a free tool used to administrative MySQL database in a GUI mode ( Using web browser ) . You can perform almost all the major tasks like creating , deleting  and modifying databases, tables, rows etc. you can also optimize and repair tables just with a single click .

Phpmyadmin on ubuntu 12.04 :

Inorder to install phpmyadmin on ubuntu 12.04, you need 3 main packages apache , MySQL and php has to be installed and configured properly. You can refer the below posts to install, configure and test the apache, mysql and php together.

1. Apache2 installation

2. Mysql installation 

3. PHP installation 

4. Testing all together

After installing apache2, mysql and php, you can continue with the below steps toinstall and configure phpmyadmin

Step 1 » Update ubuntu repositories by giving the below command

krizna@leela:~$ sudo apt-get update

Step 2 » Type the below command to install phpmyadmin .

krizna@leela:~$ sudo apt-get install phpmyadmin

Step 3 » You will prompted to choose the type of web server for phpmyadmin . just choose “apache2″  (use space bar and enter key for selecting ) .phpmyadmin on ubuntu 12.04Step 4 » Now the installation will prompt for the mysql database configuration ,As we already configured mysql server manually just choose “No” and hit enter to complete the installation.install phpmyadmin ubuntu 12.04

Step 5 » That’s it , now open the path “http://localhost/phpmyadmin” in the browser , you will prompted for username and password . just type Mysql root username and password given during the Mysql installation . Now after successfulllogin , you can see the screen like below .install phpmyadmin ubuntu 12.04

If you are getting “Page not found” issue .Include the below line in/etc/apache2/apache2.conf file.

Include /etc/phpmyadmin/apache.conf

and restart apache2 service

sudo /etc/init.d/apache2 restart

S: http://www.krizna.com/