How To Install MySQL Server on Windows7

HOW TO INSTALL MYSQL SERVER ON WINDOWS 7

Introduction:

MYSQL is Open Source database

and it can be easily be installed on

windows 7

Download & Installation

Download

You can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 5.0.24 a at the time of writing.

Installation of MySQL Server

Unzip the setup file and execute the downloaded MSI file. Follow the instructions below exactly when Installing MySQL Server.

Configure MySql Server:

If you checked the Configure the MySQL Server now check box on the final dialog of the MySQL Server installation, then the MySQL Server Instance Configuration Wizard will automatically start.

Follow the instructions below carefully to configure your MySQL Server to run correctly with

EventSentry.

Note:

It is recommended that you use a Dedicated MySQL Server Machine for your

MySQL database, if this is not an option then select "Server Machine".

Note:

Select Transnational Database Only, this will make sure that InnoDB is the main storage engine.

Note:

Select the drive where the database files will be stored.

Select the drive on the fastest drive(s) on your server.

Note:

Enter the number of agents you are monitoring, multiplied by two.

For example, if you are monitoring 20 servers then enter 40.

Note:

It is recommended that you leave the default port 3306 in place, however

EventSentry will also work with non-standard ports if necessary.

Note:

It is highly recommended that you run the MySQL Server as a Windows

service and include the binary directory in the search path.

Specify a secure root password, you may want to check the box Enable root access

from remote machines if you plan on administering your MySQL server

from your workstation or other servers.

Note:

If you see this dialog then your instance was setup correctly