OK – so where are we?
We have a working Apache2 server. We’ve created a couple of Virtual Hosts, and can access them from the outside world via dyndns.com.
What’s next – setting up a usable mySQL system. The easiest way to maintain multiple mySQL databases is with phpMyAdmin. This is a standard Ubuntu package, and is very easy to install to run from the default Apache host. But a couple of notes first.
Note that ‘localhost’ is the default mySQL server name assumed by a lot of php software packages that you’re likely to use (such as WordPress). And under the setup we’ve built so far, it is the default site that is ‘localhost’. You can see this by opening a Firefox browser inside your Ubuntu VM (or real hardware), and entering “http://localhost” to the address box – and you will get the home page of the default host – which still should be at
Note that any domain names you’ve defined using dyndns.com to map to your Ubuntu server will use the default site unless you’ve set up some virtual site hosts. In the default configuration,
/var/www/ is owned by root. This isn’t easy to work with – edit, etc. There are at least three ways to make it easy for you to use the default host directories. The laziest is to just chown and chgrp
/var/www/ to your own username/group. You also could change the default Apache site configruation file to use a directory on your own home directory, or you can use symbolic links. I used chown.
OK – so let’s install phpMyAdmin on the default localhost directory. Here’s what you have to do. From a terminal, enter:
sudo apt-get install phpmyadmin. It’ll do the usual stuff, and now it is ready to go. To use it, simply enter “http://localhost/phpmyadmin” into your local browser, or a domain name that maps to the default host from any browser. I won’t go into the details of using phpMyAdmin here.
I would just like to say I set up a similar Ubuntu server over a year ago, and it was not at all this easy. It seems to me you can start from scratch and install and build a complete Ubuntu 8.10 Desktop with Apacache2, mySQL, php5, and phpMyAdmin in less than two hours. I hope your installation goes as smoothly.
Next – WordPress.