Ubuntu Server 12.04: How to Enable phpMyAdmin Tips, Tricks and Tutorials 01 JUL 2014

The last little while I’ve slowly been bringing all our servers up to a base level of operating system, in this case Ubuntu Server 12.04 LTS (Waiting for 14.04 LTS to become a little more ‘in use’ before making the jump), and I came across a server that didn’t have the ubiquitous phpMyAdmin installed. We’re (Touchwork) essentially a LAMP development house, which of course then means that phpMyAdmin is almost always present as a nice quick and easy database manager for the simple stuff.

Anyway, to add it to an existing Ubuntu Server install is pretty simple as one would expect, so these notes are more for my own reference than anything else:

sudo apt-get update
sudo apt-get install phpmyadmin

The installer will ask you to set up for either Apache2 or lighttpd and from there it is a matter of following the onscreen instructions. You’ll be asked for the MySQL root password which would have been set during the MySQL server install, so be sure to have that on hand. (Note, the default install directory will be /etc/phpmyadmin, so all the config files will be there for later on tweaking if you are so inclined).

Chances are pretty high that when you hit your server at the expected phpmyadmin URL (e.g. http://myserver.com/phpmyadmin) you’ll be served with a Page Not Found error, which you can then fix by simply telling Apache that it should be expecting phpMyAdmin – basically just include line below (it should be missing) at the end of the /etc/apache2/apache2.conf configuration file:

include /etc/phpmyadmin/apache.conf

Save your changes and restart or reload the apache2 service:

sudo service apache2 reload

Quick and painless.


Related Posts:

About Craig Lotter

Software developer, husband and dad to two little girls. Writer behind An Exploring South African. I don't have time for myself any more.