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.


MySQL Package for Windows

Step 2: Double-click the downloaded file. 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;


Post a Comment

40 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.
  1. സർ ,
    ഉബനദു ഡൌണ്‍ലോഡ് ചെയാൻ ഒരു മാർഗം പറഞ്ഞ് താരുമോ ?

    ReplyDelete
    Replies
    1. It school Ubuntu 18.04 can be downloaded from kite.kerala.gov.in/downloads (4.3 GB)

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

    ReplyDelete
  3. how can we edit queries in mysql

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

    ReplyDelete
  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
    CLICK HERE

    ReplyDelete
  6. sir sql download cheythu kazhijitum status complete avunilla

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

    ReplyDelete
  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

    ReplyDelete
  9. @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

    ReplyDelete
  10. http://filehippo.com/download_mysql/

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

    ReplyDelete
  12. Sir,
    How I can create a server in my windows PC . I installed MySQL on my windows PC successfully , thanks for making MySQL on windows. Please tell me how to make server in Windows PC . As a computer science student it will be very helpful for me and my classmates

    ReplyDelete
  13. ERROR IN INSTALATION. SEURIRY ERROR. ERROR NO 2003. CAN NOT CONNECT TO MYSQL SERVER TO LOCALHOST (10060) THE SECURITY SETTING COULD NOT BE APPLIED TO THE DATABASE . PLEASE HELP HSSLIVE TEAM. WINDOWS 7. 9895371787

    ReplyDelete
  14. While installing MySQL server instance configuration wizard there is a current root password.How i get this current root password?

    ReplyDelete
  15. Can I Get Sql plus...?

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete
  17. windows 8 c++ download chayyan lnk tharamo

    ReplyDelete
  18. Can you please help me with 'root' password....for istalling my sql

    ReplyDelete
  19. MySQL databases are accessible to all major programming languages which have language-specific APIs including Libraries. For other programming languages, an ODBC interface called MyODBC allows the interface to communicate with a MySQL database such as ASP or ColdFusion.dbdesigner.net

    ReplyDelete
  20. A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Windows 10

    ReplyDelete
  21. What is the current password what is root password

    ReplyDelete
  22. can you give the upload to download sql for ubuntu 14.04 of 32 bit

    ReplyDelete
  23. Sir where is questions for the solved problems (physics)......

    ReplyDelete
  24. How to write a query of set operations

    ReplyDelete
  25. Sir ee sql ഞാൻ ഡൌൺലോഡ് ചെയ്തു പക്ഷെ ഡിസ്പ്ലേ സ്‌ക്രീനിൽ ഒരു battents um kannanillaa ഇത് എങ്ങനെയാണ്
    Buttents undakkukkaaa

    ReplyDelete
  26. A few games even add robots and animals as playable characters to try not to have issues with portrayal. CPS Test Online

    ReplyDelete
  27. On this subject internet page, you'll see my best information, be sure to look over this level of detail. 토토

    ReplyDelete

Top Post Ad

Below Post Ad