MySQL Installation on Windows PC

MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

Log into the computer as an administrator. This will give you administrator rights, which will make the installation smoother. Note that, once installed, the program doesn’t need to be run as an administrator.

To properly install and configure MySQL on your Windows PC, follow these instructions.

Step 1: Download the free MySQL Server Community Edition from MySQL Download Page. Be sure to download a version that includes a Windows Installer. Save the file on your Windows Desktop. If you’re not sure which version to select, download MySQL Installer for Windows from our mirror Link.

Step 2: Double-click the downloaded file mysql-essential-5.1.30-win32 .This will initialize the setup process.
Step 3: Click Next. This begins the setup.

Step 4: Click Custom > Next. This will enable you to specify where you want to install MySQL.
Step 5: Change the default folder and drive.
Step 6: Click Install. Wait while the program self-installs.
Step 7: Click Next in this Enterprise Edition Alert
Step 8: Your new dialogue box should say Wizard Completed. Leave the check box "Configure the MySQL Server Now" checked and click Finish.
Step 9: Check the start menu for the item " MySQL Server Instance Config Wizard " and click.This will initialize the configuration setup
Step 10: The configuration wizard will allow you to configure the MySQL Server 5.1. To continue click Next.
Step 11: Check "Standard Configuration " and then click Next. This is the default configuration and is recommended for most users.
Step 12: Make sure "Install As Windows Service" and "Include Bin Directory on the Windows Path" are checked, then click Next.
Step 13: Create a root password. Type in what you want your root password. Then click next.
Step 14: Click Execute. This will start the MySQL server. After MySQL has done its thing, click Finish.
Step 14: Press Finish to Close the Wizard
Step 15: Check Start menu for the item "MySQL Command Line Client" and click.
Step 16: This will open a command window asking you for a password.Enter your root password and hit Enter. This should initiate the program
Step 17: Before executing SQL Commands do the folowing on mysql prompt(mysql>) . Type "Connect mysql;" in SQL prompt.

Step 18: Only after connecting to a database you can execute SQL Queries.
Check the following sample Queries....

Create table student(roll int primary key,name char(20));

Insert into student values('1','HSSLiVE');

Select * from student;

Share This:

We need you to spread education. Join this effort to contribute, to learn or just to share your knowledge. For more details, please follow the link Share Your Knowledge.

20 comments to ''MySQL Installation on Windows PC"

  1. സർ ,
    ഉബനദു ഡൌണ്‍ലോഡ് ചെയാൻ ഒരു മാർഗം പറഞ്ഞ് താരുമോ ?

  2. How can we get a mysql command window in full screen

  3. how can we edit queries in mysql

  4. Sir, PHP install cheyyan kazhiyunnilla.instructions anusarichaanu cheythathu.ennittum "failed" ennu paranju karikkunnu...what to do?pls reply

  5. @Anju Suresh
    The explanation given here is correct ,but it is confusing.Neverthless it is useless for you.Because it dosent contain Apache and MYSQL server or u need to install those seperatly.So Only Download Xamp or Wamp(For ubuntu LAMP).

    Here's the link

  6. sir sql download cheythu kazhijitum status complete avunilla

  7. tnx for the software and the instructions for its installation

  8. you may not be able to start MYSQL SERVER when WAMP or XAMP server is installed.If you need to work both you have re configure the MYSQL settings.Here is the link it may be use full to you.

    Click here

  9. i have instakled it succesfully insatlled but the final step.
    The My Sql software is not opening.
    What should i do.

  10. @Manu Sam
    Do you feel any trouble in instalation?.If you are unable to open you have then another guide here try this...

    click here for guide


  12. I can't open mysql ,i forgot my root password. please help me


  • To add an Emoticons Show Icons
  • To add code Use [pre]code here[/pre]
  • To add an Image Use [img]IMAGE-URL-HERE[/img]
  • To add Youtube video just paste a video link like