MySQL installation

MY SQL is a popular open source database which is been widely used by many organizations effectively. Since it is an open source it can be installed on Windows, Unix, Linux etc.

Default port of MY SQL is 3306 and for each instance of MY SQL on the same server box port number needs to be changed in my.cnf or my.ini file.

This document is about installing MY SQL on windows and working on MY SQL databases:

Step 1. Download MY SQL 5.1 version from http://dev.mysql.com/downloads/mysql/:

MY SQL Installation:

Step 2. Here MY SQL 5.1 version installation is copied on D: drive. Just click on it as highlighted below:

Step 3. Click Next and select the setup type as required by the project needs.

          Step 4. Click Next and choose MY SQL server and other icons one by one and click on Change button to provide the location destinations.

                Step 5. Click on change to change the location of the files.

                Step 6 Click on Install

                Step 7. Click Finish to start configuration:

                Step 8. Click Next-> Here standard configuration is chosen and according to the                requirement this can be chosen accordingly.

               Step 9.  Click Next and also check Include Bin Directory in Windows Path so that when login in to mysql, it may not  be necessary to get in to bin folder path of MY SQL.

                Step 11. Click Next and provide New root password as required and do not check the box for Create an Anonymous Account for security reasons.

 Click Next and click on Execute button.

Step 12. Click Finish

After installation we can find the below directories which are created after installation, where my.ini is the configuration file. Any modifications can be done using this file like changing the port, engine, Replication activities etc.