Ok i recently cam across this CMS (content management system) called drupal. Its released under the GPU/GPL and is very easy (but can be confusing) to install so heres how:
1. Go to
www.drupal.org and download the .tar.gz (it works on all platforms windows or linux)
2. Unpack the files
3. Upload them to your server
4. Login to phpMyAdmin and create a DB for drupal, next import the DB structure by clicking import, next browse for the file, the file is loacted in the "database" directory of drupal. I used "database.4.1.mysql"

*optional* Once the database is setup you can create and account for use with drupal, so if drupal is compromised your other databases will not suffer.
5. Next go into the drupal folder then into sites then into default, you will see a file named "settings.php" Open it (i used php designer pro 2007, settings.php will have some strange errors in it if you open it with notepad (since it was coded on a linux box the conversion causes errors. THE FILE IS NOT CHANGED! JUST HARD TO READ!) use a program that will help you read the file, if you are unable.
http://www.vim.org/download.php#pc works from what i hear)
6. Now look for
$db_url =
7. Change whats after it to look like this:
mysqli://username:password@localhost/database
Username="The username for drupal"
Password="the password for drupal"
Database="the database for drupal"

NOTE! The above URL is mysqli, you can take the i out if you get errors that drupal cant connect to the database, after editing this file.
8. After making the changes, save the file, then navigate to the drupal folder.
9. You will see a link with "Create the first account here" click it, enter a username, then enter a
VALID!!! e-mail address.

10. After you finish that drupal will be installed, you can change the password for your first account and do other stuff with drupal. For more help go to: http://drupal.org/forum

Hope this helps, if there is a problem with the tutorial, post it and i will fix it