Installing MySQL on Windows

Downloading MySQL 

The latest version of MySQL can be downloaded from http://www.mysql.com. In this tutorial we are using mysql-essential-5.0.24a-win32.msi, which is the latest version of MySQL at the time of writing the tutorial. You download the windows installer from http://www.mysql.com and save on your hard disk.

Understanding the MySQL Installation wizard
MySQL Installation Wizard uses the new installer technologies for Microsoft Windows. And that?s why it is an installer for MySQL server. This MySQL installation wizard is combined with the MySQL configuration wizard which allows user to install and configure a MySQL server, and it can be used immediately after installation. MySQL provide the standard installation for all MySQL Server distribution or higher version 4. 1. 5 . In this version MySQL need to shout down and remove their existing MySQL installation and manually installation before the MySQL wizard.  This installation process use of this technology to provide a smoother and flexible process.

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

MySQL Installation Wizard made some Changes
MySQL installation wizard can begin the process of installation only after clicking the Install button and make some changes to your system that describe in the following section -

Change to the Registry:
MySQL installation wizard generate one windows registry key in the situation of typical installation, that is located in HKEY_LOCAL_MACHINE\SOFTWARE\MySQL AB.
MySQL Wizard generates a key that is named after the major version of server which has been installed, like MySQL Server 5.0. It has two String values one is Location and another is Version. The location has the path to installation directory. And the version has the release number.

MySQL used these registry keys to help external tools to identifying the installed location of the MySQL server. This Registry keys does not required to run server and you want to install MySQL using the noinstall zip archive, then the registry keys are not created .

Change to the Start Menu:
MySQL installation  wizard create a new entry in the start menu windows. This MySQL menu heading named after the major version of MySQL that you have to installed. There are some entries are created with in the new start menu section :

MySQL command Line Client: This is shortcut for the MySQL command - line client and is configured to connect the root user. The shortcut prompts for a root user password when  you connected .
  
MySQL server instance configuration wizard: This is a shortcut for the Configuration wizard . For configuring the new server or reconfiguring the existing server you can use this shortcut.
 
MySQL Documentation: MySQL Documentation is the link to the MySQL Server documentation and it is stored in the installation directory. But if you have installed the Essential installation package then this option is not available.
 
Change to  the file System: 
By default the MySQL server installs to C:\Program File\MySQL Server 5.0 location. On a developer machine a typical MySQL installation can be look like this :

MySQL Testing the Installation 

MySQL Downloading and Installing wizard
This installation package can be download from http://dev.mysql.com/downloads/. But you have to extract this zip archive first. If there is setup.exe is available then double click on this file for starting the installation. But if there is an .msi available then double click on this

Ask Questions?    Discuss: Installing MySQL on Windows   View All Comments

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):
 
 
 

Comments

Ralph Reed
April 10, 2011
command line missing

---

The command line is missing from the MySQl install I did, since I am running Windows 7 64bit I am having to just through hoops to get the program to work correctly, I did manage to get the server installed and configured correctly but the class I am taking for school says I need to use the command line for everything right now but that didn't install, any ideas as to how to fix thix?

evelyn nyarai kufa
October 18, 2011
how to run the my sql

---

my sql been installed succeesfully now l want to know how to run it on my computer

Neeraj Garg
November 5, 2011
mysql

---

good

miral virani
November 12, 2011
like php

---

thanx............... because you can share you knowledge with me................... And also increment my knowledge........................use your website

sangeeta
January 23, 2013
mysql command line client installation

---

database work

Vivek Patel
February 3, 2012
mysql

---

it is nice.

PC diagnostic tools
April 3, 2012
SO that's it?

---

Could you tell me, why I can't open the command line after the SQL install? It simply disappears, once I click on it.