How to Install MySQL 5.x on Windows XP Pro

Download the MySQL msi install file
http://dev.mysql.com/downloads/ ( MySQL Community Server - Current Release - Windows Essentials)
Double click it and press Run to start the install
Press Next
Select Typical
Press Next
Press Install to install to C:\Program Files\MySQL\MySQL Server 5.x
Press Next
Press Next
Press Finish to Configure the MySQL Server
Press Next to to start the Configuration Wizard
Select Standard Configuration and Press Next
Check both boxes, Install As Windows Service and Include Bin Directory
Press Next

Add a root password if you wish or else uncheck Modify Security Settings.
If you do add a root password, once you install the Personal Server, you will have to edit the Personal Server config file to add the password. The config file will be C:\Inetpub\wwwroot\cinemapremiereps\configdb.php (or \cinemapremiereps\configdb.php if you installed a different web server.) For the Test it will be C:\Inetpub\wwwroot\cinemapremierepsTest\configdb.php (or \cinemapremierepsTest\configdb.php if you installed a different web server.)
You can open configdb.php with notepad and add your password in the db_password field between the single quotes.
Save the file.
Press Next
Press Execute
Press Finish to close the Wizard
Once you have installed the web server, php, MySQL, and the personal server, you should reboot your computer before testing the movie manager.