Wednesday, October 5, 2016

Installing MySQL 5.7.15 on Microsoft Windows 7

Prerequisites:
To be able to install and run MySQL 5.7.15 your System needs to have library Microsoft .Net Framework installed.
Download and Install Microsoft .Net Framework
1.Download Microsoft .Net Framework from below link
and Click on Download button to download Installer file.
2. Move to the folder to which the MSI file was downloaded and double-click on it to start  Microsoft. NetFramework Installer. – click “Yes” when prompted.


3. Accept the terms in the License   by checking the box and hit “Install”.
             
4. It would take some time for the progress bar to start moving… be patient.
5.Finally Click on Finish button.
Download and Install MySQL 5.7.15
  1. Download MySQL 5.7.15 from this link   http://dev.mysql.com/downloads/installer/
  2. please click on that link to load it in a browser
  1. Scroll down and locate the MSI installer file corresponding to your system type – 32 bit or 64 bit. Click the Download link/button beside it as below.
  1. You will be asked to register or sign in at your account. Registering has its benefits, but if you are in a hurry, simply click on the No thanks, just start my download! Link its automatically gets downloaded.


Setting up MySQL

  1. Move to the folder to which the MSI file was downloaded and double-click on it to start MySQL installation – click “Run” when prompted.



  1. Selecting “Yes” prompts another window as below and take few minutes for processing.


  1. Accept the terms in the License Agreement by checking the box and hit “Next”.


  1. Choose the appropriate Setup Type for your system. Typically, you will choose Developer Default to install MySQL server and other MySQL tools related to MySQL development, helpful tools like MySQL Workbench. Or, choose the Custom setup type to manually select your desired MySQL products. Here I am selecting Custom Setup Type.


  1. Select the products from MySQL package as below screen. As per my requirement I am selecting MySQL-Server 5.7.15(X86).
  1. You are now ready to install MySQL on Windows 7 operating system. Click “Execute”.
  1. Later It will prompt following wizard and take time for Execution.
  1. After successful Execution It will prompt following window and click “Next”
  1. Click on “Next” to configure the MySQL
  1. Select the Config Type as Development Machine from different config types as below.
  1. Click on “Next”
  1. The password for the MySQL server instance has to be typed in twice as below. Remember to keep a note of it and don’t lose it. The password doesn’t have to be very strong because, I suppose, you would be using MySQL on your computer for learning/development and NOT production. And hit “Next”.
If you want to add User, you create user by clicking “Add User” button from below instructions. This is optional one.


Here provide the password for twice enable OK to create user.
  1. Click on “Next” button
  1. The configuration window prompts Plugins and Extensions Wizard. Just hit “Next”
  1. Finally, Server Configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click “Execute” button
  1. After Successful configuration it enables Message to Click on “Finish” button
  1. Product Configuration Completion Wizard Appears with successful completion of our selected product. Check once and hit on “Next”
  1. After successful completion of our selected products will prompts Product completion wizard simply click on “Finish”.

Checking the MySQL installation
  1. The easiest way to check MySQL installation and confirm that it’s working properly is to use the MySQL Command Line Client. Fire it up from “All Programs” -> “MySQL” -> “MySQL Server 5.7“
  1. Now enter the MySQL password – the characters you type will be replaced by the asterisk sign (the password is not shown for security reasons – obviously).




  1. The MySQL client displays the MySQL> prompt on successful login.
  1. Type show databases; (the semi-colon at the end is not a typo) and hit the enter key. This simple SQL command instructs MySQL to display the names of the installed databases and there should be four of these. Hurray! Rejoice because you have been able to correctly install MySQL on Windows 7.

6 comments:

  1. Software Solutions-computergk is a leading name in the worldwide IT Industry for providing a wide array of software development services, tailor-made solutions and software merchandise. we offer climbable, flexible, strategic finish to finish technology solutions and software development services. Our ability to create by mental act, implement and expand our capabilities with demanding quality permits customers to remodel their businesses to successive level.

    ReplyDelete
  2. I like your blog, I read this blog please update more content on hacking,
    Nice post
    Tableau Online Course

    ReplyDelete
  3. The tutorial is very helpful for a first timer like me, by the way if you could have given a
    tutorial on creating a free blog, it would have been very helpful for newbies like me.

    click for info

    ReplyDelete
  4. This is really a nice post, this will really help a lot who is facing issue in installing MySQL on Microsoft.
    Keep Posting
    Also visit- CCSP Training

    ReplyDelete
  5. It is a lot easier to use! it's great. The best msbi online training offers the best solutions for Business Intelligence and data mining. MSBI uses Visual Studio data tools and SQL servers to make great decisions in our business activities.

    ReplyDelete