In the next window of the configuration wizard, you are asked if you want to install MySQL as a Windows service and if this service should be started with the server. Additionally, you are asked to decide whether to add MySQL commands to the Windows path. I made the wise choice to let the MySQL service start with the operating system and chose to modify the system path. (Figure 11)
The security of the network server and database is also an important factor. Likewise, you should set a secure root password for your database server; disable remote root access unless absolutely necessary, and do not create anonymous accounts. (Figure 12)
Security settings are the last configuration items in the wizard. Once the setup is complete, the wizard is ready to configure, write the configuration information to the C:Program Files [{x86}]MySQLMySQL Server 5.0my.ini file, and then start the database service.
Now, you have set up a functioning MySQL database server. Now we turn to PHP.
Step 4: Install and Configure PHP
This is probably the hardest part of the whole process. Getting PHP to work with IIS 6 can sometimes be a challenge. I'll explain it in full below.