How to Install MySQL 5.x on Windows XP Pro

1. NOTE: The following steps may be slightly different depending on the version of MySQL you are installing.
2. NOTE: Newer versions of MySQL have the my.ini configured to have the database files in C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/ instead of in C:\Program Files\MySQL\MySQL Server 5.1\data.
3. Download the MySQL msi install file ( MySQL Community Server - Current Release - Windows Essentials)
4. Double click it and press Run to start the install
5. Press Next
6. Select Typical
7. Press Next
8. Press Install to install to C:\Program Files\MySQL\MySQL Server 5.x
9. Press Next
10. Press Next
11. Press Finish to Configure the MySQL Server
12. Press Next to to start the Configuration Wizard
13. Select Standard Configuration and Press Next
14. Check both boxes, Install As Windows Service and Include Bin Directory
15. Press Next
16. Add a root password if you wish or else uncheck Modify Security Settings.
    1. 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 <root>\cinemapremiereps\configdb.php if you installed a different web server.) For the Test it will be C:\Inetpub\wwwroot\cinemapremierepsTest\configdb.php (or <root>\cinemapremierepsTest\configdb.php if you installed a different web server.)
    2. You can open configdb.php with notepad and add your password in the db_password field between the single quotes.
    3. Save the file.
17. Press Next
18. Press Execute
19. Press Finish to close the Wizard
20. Once you have installed the web server, php, MySQL, and the personal server, you should reboot your computer before testing the movie manager.

Previous | Next | Top