So you have installed and got PHP running on Vista/IIS 7, the next thing to do is to install MySQL. I had some issues with MySQL 5.0.51a so I stuck with MySQL 5.0.45.
Download a copy of MySQL from:
http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.45-win32.zip
Before you run the setup you will need to disable the User Account Control (UAC)
- Open Control Panel in classic view
- Select User Accounts
- Click on Turn User Account Control on or off
- uncheck Use User Account Control and then click on OK
- Accept the restart message
Note you can enable this once everything has been installed.
Now your ready to go ahead with the MySQL installation.
Locate and extract the file you downloaded. Run Setup.exe
Follow the bellow screen shots, to enlarge click on them, if you hover your mouse over you will be given a description of what to do.
If you get an error message on the Applying Security Settings click on Retry. this message is more than likely due to the service not starting quickly enough. It will work if you hit the retry button it did for me.
Install the MySQL Administrator
- Download the GUI Tools (Windows x86) from: http://dev.mysql.com/downloads/gui-tools/5.0.html
- Install just as you would do with any other install (next, next, accept the license agreement etc...)
- Run the MySQL Administrator:
Click Start, All Programs, MySQL, MySQL Administrator
- Fill in the details as show below (click to enlarge)
- To create a new database in the MySQL Admin Select Catlogs:
- Right Click in the white area under the other Schemas
Select Create Schema
- Give that new Schema a name and there you go, you have just created a new MySQL Database
