Installing MySQL Server
Many applications written in PHP require MySQL database server. You could download free “MySQL Community Server” from the following location: http://dev.mysql.com/downloads/mysql/5.1.html
Select your platform (Windows and then 32- or 64-bit edition) and then download “Windows Essentials” package (usually it’s a smallest one under selected platform).
Run the installation wizard and select “Typical” on “Setup Type” step:
After the installation is completed proceed to MySQL service configuration:
Select “Standard Configuration” and click “Next” button:
Specify settings for MySQL Windows service:
And then specify a password for “root” account:
Click "Enable root access from remote machines". In some cases this could simplify configuring MySQL for your applications.
At the next step click "Execute" button. All configuration steps must be successfully completed:
To test MySQL service you could open command line interface, switch to MySQL installation folder and perform some commands (e.g. display the list of available databases) against MySQL engine as shown on the figure below: