application , security , web-services

MySQL Installation Notes on Windows 200x and IIS 6 / 7

October 13, 2009

This document describes the steps necessary to do a basic mySQL database engine installation on a computer running Windows 2000x Server and IIS 6.

What you’ll need

Windows 200x Server running Internet Information Server (IIS) 6.0

A copy of the mySQL binary distribution for Windows NT / 200X

The Steps:

Download the mySQL binary for Windows NT /200x from mysql.com downloads

Unzip the archive using WinZip or other utility to a temporary folder.

Run the setup.exe program

Install to c:mysql. If you want to install it somewhere else, install it there first and move it later.

Open a command prompt (Start, Run…, type cmd)

Switch to the c: drive

Type cd mysqlbin

Load the mySQL daemon: type mysqld –install

Close the command prompt window

Go to Start, Control Panel, Services

Highlight the line with mySQL and make sure the Startup column says Automatic. If not, click Startup, Automatic.

Click the Start button in the Services toolbar to start the mySQL service.

Close the Services Manager.

That’s it. You are now ready to create a mySQL table and populate it with data.

www.bestitdocuments.com