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!
