More

    Installing and Setting up MySQL Community Server on Windows for Development

    MySQL is provided in two editions primarily: the commercial MySQL Enterprise Edition and the open MySQL Community Edition. We will try to install and set up MySQL Community Server.

    STEPS

    1. You can download the MSI version of the MySQL Community Server from http://dev.mysql.com/downloads/mysql
    1. Download the latest stable GA version.
    2. Download the one with larger size.
    3. Once you click on download, It might ask for ‘Login Now or Sign Up for a free account’, but you can also click on ‘No thanks, just start my download’ at the bottom.
    1. Double click on the installer to install.
      1. Accept license and click next
      2. Select Developer Default and click next
      3. Click on execute.
      4. Accept license for installing any prerequisites
      5. It might ask a popup for failing system requirements, say “yes” is you don’t want those features. Else install them manually first. You can also do this later; so just say “yes” and continue.
      6. Click execute again on the products listing screen.
    2. Click next for product configuration
      1. Leave the port as 3306.
      2. Set a root password and save it in some place secure.
      3. Leave the defaults selected in the Windows Service configuration page.
      4. Click execute on the final page.
    3. Click next to connect to the server and check.
    4. Click execute on the Apply Server Configuration page.
    5. Click Finish selecting option to start workbench. 
      1. Workbench in the graphical user interface through which you can manage your MySQL Server.
    6. Connect to your local instance from the workbench to see if everything is fine.

    SCREENSHOTS

    Product lists installed

    Please post a comment if you get stuck in any step.

    Recent Articles

    OAUTH – FREQUENTLY ASKED QUESTIONS FOR INTERVIEWS AND SELF EVALUATION

    Why is refresh token needed when you have access token? Access tokens are usually short-lived and refresh tokens are...

    SUMO LOGIC VIDEOS AND TUTORIALS

    Sumo Logic Basics - Part 1 of 2 (link is external) (Sep 29, 2016)Sumo Logic Basics - Part 2 of 2...

    GIT – USEFUL COMMANDS

    Discard all local changes, but save them for possible re-use later:  git stash Discarding local changes...

    DISTRIBUTED COMPUTING – RECORDED LECTURES (BITS)

    Module 1 - INTRODUCTION Recorded Lecture - 1.1 Introduction Part I – Definition

    BOOK REVIEW GUIDELINES FOR COOKBOOKS

    Whenever you add reviews for the book, please follow below rules. Write issues in an excel.Create an excel...

    Related Stories

    Leave A Reply

    Please enter your comment!
    Please enter your name here

    Stay on op - Ge the daily news in your inbox