phpMyAdmin is the best option for managing MySQL databases through web interface. Its very easy to use and provides almost all the option to work with your MySQL server. It also provides an easy way to configure mysql replication with few steps.
Step 1: Install Apache2, PHP and MySQL
We assume you already have installed LAMP setup on your system. If you do not have installed, Use following command to install it. Below command will install Apache2, PHP5 and MySQL server in your ubuntu system.
$ sudo apt-get install apache2 php5 mysql-server
Step 2: Install phpMyAdmin
After installing LAMP stack, lets install phpMyAdmin using below given command in your Ubuntu system
$ sudo apt-get install phpMyAdmin
Step 3: Configure Apache2 for phpMyAdmin
After installation of phpMyAdmin it creates an configuration file for apache2. Edit apache2 main configuration file /etc/apache2/apache2.confand add following line at the end of file.
After updating above entry, restart apache2 service using following command
$ sudo service apache2 restart
Step 4: Access phpMyAdmin in Browser
You phpMyAdmin installation has been completed successfully. Open you favorite web browser and open below url to access phpMyAdmin
If you are accessing from remote system, change localhost to system ip address.