Step-by-Step guide for Installing MySQL on Windows

Step-by-Step guide for Installing MySQL on Windows

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.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"

MySQL Installing Type
There are three type of MySQL Installation:-

Typical 
This MySQL installing process install the  MySQL server,command- line client and command line utilities. This command line and command client included in mysqldump, myisamchk and several tools to manage the MySQL Server.

Complete
By this installation type we install all the component included in the installation package. And this package include the component such as support script, the embedded server library. MySQL complete installer also included the benchmark suit and documentation.

Custom
MySQL is use Custom installation type command that provide you the complete control over package that you want to install and also the installation path. If you choose the Custom type then you can change the installation path or components , which is installed by Installation Wizard

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  EventSentry.

Select Detailed Configuration

• Developer Machine:

          Choose this option for a typical desktop workstation where MySQL is intended only             for personal use. It is assumed that many other desktop applications are running.               The MySQL server is configured to use minimal system resources.

• Server Machine:

 Choose this option for a server machine where the MySQL server is running alongside other server applications such as FTP, email, and Web servers. The MySQL server is configured to use a moderate portion of the system resources.

• Dedicated MySQL Server Machine:

Choose this option for a server machine that is intended to run only the MySQL server. It is assumed that no other applications are running. The MySQL server is configured to use all available system resources.

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.

 MySQL Server Instance Config Wizard: The Database Usage Dialog

The Database Usage dialog enables you to indicate the storage engines that you expect to use when creating MySQL tables. The option you choose determines whether the InnoDB storage engine is available and what percentage of the server resources are available to InnoDB.

·  Multifunctional Database: This option enables both the InnoDB and MyISAM storage engines and divides resources evenly between the two. This option is recommended for users who use both storage engines on a regular basis.

  Transactional Database Only: This option enables both the InnoDB and MyISAM storage engines, but dedicates most server resources to the InnoDB storage engine. This option is recommended for users who use InnoDB almost exclusively and make only minimal use of MyISAM.

  Non-Transactional Database Only: This option disables the InnoDB storage engine completely and dedicates all server resources to the MyISAM storage engine. This option is recommended for users who do not use InnoDB 

Some users may want to locate the InnoDB tablespace files in a different location than the MySQL server data directory. Placing the tablespace files in a separate location can be desirable if your system has a higher capacity or higher performance storage device available, such as a RAID storage system.

Select the drive where the database files will be stored.
Select the drive on the fastest drive(s) on your server

MySQL Server Instance Config Wizard: The Concurrent Connections Dialog

To prevent the server from running out of resources, it is important to limit the number of concurrent connections to the MySQL server that can be established. The Concurrent Connections dialog enables you to choose the expected usage of your server, and sets the limit for concurrent connections accordingly. It is also possible to set the concurrent connection limit manually.

• Decision Support (DSS)/OLAP:

Choose this option if your server does not require a large number of concurrent connections. The maximum number of connections is set at 100, with an average of 20 concurrent connections assumed.

• Online Transaction Processing (OLTP):

Choose this option if your server requires a large number of concurrent connections. The maximum number of connections is set at 500.

• Manual Setting:

Choose this option to set the maximum number of concurrent connections to the server manually. Choose the number of concurrent connections from the drop-down box provided, or enter the maximum number of connections into the drop-down box if the number you desire is not listed.

MySQL Server Instance Config Wizard: The Networking and Strict Mode Options Dialog

Use the Networking Options dialog to enable or disable TCP/IP networking and to configure the port number that is used to connect to the MySQL server.

 TCP/IP networking is enabled by default. To disable TCP/IP networking, uncheck the box next to the Enable TCP/IP Networking option.

Port 3306 is used by default. To change the port used to access MySQL, choose a new port number from the drop-down box or type a new port number directly into the drop-down box. If the port number you choose is in use, you are prompted to confirm your choice of port number.

It is recommended that you leave the default port 3306 in place, however
EventSentry will also work with non-standard ports if necessary

MySQL Server Instance Config Wizard: The Character Set Dialog

The MySQL server supports multiple character sets and it is possible to set a default server character set that is applied to all tables, columns, and databases unless overridden. Use the Character Set dialog to change the default character set of the MySQL server.

• Standard Character Set:

Choose this option if you want to use latin1 as the default server character set. latin1 is used for English and many Western European languages.

• Best Support For Multilingualism:

Choose this option if you want to use utf8 as the default server character set. This is a Unicode character set that can store characters from many different languages.

§  Manual Selected Default Character Set / Collation:

 Choose this option if you want to pick the server's default character set manually. Choose the desired character set from the provided drop-down list.

MySQL Server Instance Config Wizard: The Security Options Dialog

The content of the security options portion of the MySQL Server Instance Configuration Wizard will depend on whether this is a new installation, or modifying an existing installation.

• Setting the root password for a new installation

It is strongly recommended that you set a root password for your MySQL server, and the MySQL Server Instance Config Wizard requires by default that you do so. If you do not wish to set a root password, uncheck the box next to the Modify Security Settings option.

        

 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 have previously installed MySQL, but not deleted the data directory associated with the previous installation, you may be prompted to provide the current root password. The password will be the one configured with your old data directory. If you do not want to use this data, or do not know the root password, you should cancel the installation, delete the previous installation data, and then restart the installation process.

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.

Done!!!
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

If you are getting an error message after clicking the Next button, then please enable port 3306

in the Windows XP Firewall Settings

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.