For database management and administration I like PhpMyAdmin, it is easy to install it, but many people seem to have problems getting it to work under apache/ubuntu. To install and configure using the command line is very easy, below is a short guide. I presume you already have LAMP installed and configured on your machine.

Just in case you haven’t installed phpMyAdmin yet, type the following line in the Terminal:

apt-get install phpmyadmin

To set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf, first type the following command to open up this file:

gksudo gedit /etc/apache2/apache2.conf

Add the following line of code inside apache2.conf:
Include /etc/phpmyadmin/apache.conf

Now restart Apache:

sudo /etc/init.d/apache2 restart

Point your browser to: http://domain/phpmyadmin, you should be able to see the phpMyAdmin login page now!