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.
After installing apache2, mysql and php, you can continue with the below steps to install 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 ) . Step 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.
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 successfull login , you can see the screen like below .
If you are getting “Page not found” issue .Include the below line in /etc/apache2/apache2.conf file.
and restart apache2 service
sudo /etc/init.d/apache2 restart