Saturday, 15 June 2013

Installing MySQL on windows environment.


MySQL Installaion on windows. 

This tutorial will show you how to install MySQL on Windows XP. So, go to the MySQL website and download the MySQL Community Server.
File to download: Windows (x86, 32-bit), MSI Installer Essentials - Recommended if your operating system is a windows XP 64bit version use the Windows (x86, 64-bit), MSI Installer
On the downloaded MySQL double click and this will start the installation of MySQL and follow the instructions.
Select "I accept terms in the licence agreement" and click next: -


















Now you have to select installation type

Typical : it installs server as well as common client programs also.
Custom: you can choose the components to be install and the path where to install.
Complete: it installs server as well as all client programs.(Prefered if you are new to MySQL)
now we are going to see custom installaiton.
select the "custom" icon to change the path of the installation.


















Now browse or navigate to the folder C:\server\mysql we want to install the files in this folder.


















After the change press ok.



















Press install.



















It will list the configuration types
1.Detailed : While installing the mysql server, the server itself changes the configurations changes based on the available resources ( like memory,no of connections) based on the given inputs.
2.Standard : This will install the mysql server with default configuration options.
Note : standard is the best option for personal or development purpose, Detailed is prefarable only for the mysql servers.(what ever it may be the installation type, you can chage the configuration file later also).
Now we are going to install wth a standard option.
Select a standerd configuration press next.


















To install the mysql service, press next.


















We need a password for MySQL database please enter a password, please remember the login name in most cases is root and the password your choosing, in my case I choose myrootpassword.


Click on execute to install the server components.

Click on finish once everything is done.












No comments:

Post a Comment