PHPMyAdmin is a useful web-based management tool for your MySQL server running as part of your LAMP stack. To install this tool in Ubuntu turns out to be pretty simple after all.

Assuming your Apache webserver, MySQL and PHP are all already installed and up and running, open a new terminal, enter:

sudo apt-get install phpmyadmin

Follow the onscreen prompts and the installation should be complete in no time at all.

The next step is crucial if you installed the phpmyadmin to its default folder in Ubuntu – which unfortunately is not the same as the web folder! One way to fix this is to simply create a symlink like so:

sudo ln -s /usr/share/phpmyadmin/ /var/www/phpmyadmin

This basically corrects the server into serving up the phpmyadmin pages when hitting the default URL http://localhost/phpmyadmin.

And that’s that, simple as pie!

(Ubuntu 10.10 Maverick Meerkat)