Sunday, September 15, 2013

Installing MySQL on Windows

Installing MySQL on Windows


You can download the MySQL database from the MySQL website 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.1.35 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:
Click on the "setup" 

Perform a typical installation

Check box to 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

Select Detailed Configuration

I was installing it on my local machine where other applications & tools are running I decided to opt "developer machine" but 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".

If you selected Dedicated MySQL Server Machine and your MySQL service does not start after the wizard completes, then try to re-run the wizard (or re-install) MySQL, but this time select the Server Machine option.

I have checked "Multifunctional databases" as I wanted MyISAM as default storage engine but if you want you can select "Transactional Database Only", this will make sure that InnoDB is the main storage engine. If you have checked 3rd option then only myISAM engine would be available.
Select the drive where the database files will be stored.
Select the drive on the fastest drive(s) on your server

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

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

It is highly recommended that you run the MySQL Server as a Windows
service(you can disable this if you want to start it manually whenever required) 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.
If you are getting an error message after clicking the Next button, then please enable port 3306
in the Windows XP Firewall Settings


But if you are installing MySQL on a Windows XP workstation, or any other computer that has a firewall enabled, and the wizard fails with an error message similar to the one shown below (Can't connect to MySQL server on 'localhost'), then you will have to exclude the MySQL daemon from your firewall configuration.

On Windows XP, you can exclude MySQL from the firewall by following the steps below: 
1. Navigate to Start -> Settings -> Control Panel -> Windows Firewall  

2. In the resulting dialog, enter the information as shown in the screenshot

After clicking OK twice, return to the MySQL error message and select Retry. MySQL should now be able to create the instance correctly.