Installing PHPmyadmin on Kubuntu 9.10

I've now nearly fully given up on suckling from the breast of Microsoft. My little Linux laptop is now a fully functioning development box. I must say that so far I have had no separation anxiety as a result of leaving behind the sweaty manboobs of Microsoft and moving on to a more solid diet.

Anyway installing PHPmyadmin is a cinch. I used Kpackagemanager (the Ubuntu version is Synaptic) to get the package.

In retrospect I prefer the Debian apt-get approach of the command line but I like the GUI for its ability to search through all packages to discover cool new toys.

The only trick to installing PHPmyadmin is that you need to reconfigure it once it is up.

Jump to a Konsole and run the command:

sudo dpkg-reconfigure -plow phpmyadmin

This will give you the configuration options that the GUI installer does not. Specifically it sets up the config files so that Apache knows to alias the /phpmyadmin directory to the proper /etc/phpmyadmin.

If for some reason (as was the case with my Kubuntu 11.10) you need to fix the phpmyadmin Apache binding then use these commands:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/sites-enabled/001-phpmyadmin
sudo service apache2 restart

This will add phpmyadmin to Apache's list of enabled sites so that you can browse it as you would expect.