phpMyAdmin Installation on Ubuntu Server 8.04

January 26, 2009

Since managing a MySQL database through a command line is tedious we will be installing a web-based GUI so we can access MySQL through any web browser on any computer.

On many Unix machines you’d have to go to the phpMyAdmin homepage and download the files there, decompress them and set up a config files before you could get to managing your database.  If you’re setting up several machines to work in a cluster you have better things to do with your time. This is why I love Debian/Ubuntu distrobutions.

apt-get install phpmyadmin

During the install process you will be asked which version of Apache you are running.  Ubuntu Server Edition uses Apache 2.2, so it wont be automatically configured for you.  After the install process completes you will need to configure Apache 2.2, so in your favourite text editor open up /etc/apache2/apache2.conf and search for the word include.  Add a new line next to its first match like this:

Include /etc/phpmyadmin/apache.conf

Save the file, exit to your command line and restart Apache with the following command:

/etc/init.d/apache2 restart

Your phpMyAdmin installation is now ready to use. Point your browser to http://domain/phpmyadmin/ and log in with your mySQL username and password.  It’s that simple!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.