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

  https://www.microsoft.com/en-in/download/details.aspx?id=30653  

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

3. 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.

4. 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.

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

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

4. 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.

5. Select the products from MySQL package as below screen. As per my requirement I am selecting MySQL-Server 5.7.15(X86).

6. You are now ready to install MySQL on Windows 7 operating system. Click “Execute”.

7. Later It will prompt following wizard and take time for Execution.

8. After successful Execution It will prompt following window and click “Next”

9. Click on “Next” to configure the MySQL

10. Select the Config Type as Development Machine from different config types as below.

11. Click on “Next”

12. 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.

13. Click on “Next” button

14. The configuration window prompts Plugins and Extensions Wizard. Just hit “Next”

15. Finally, Server Configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click “Execute” button

16. After Successful configuration it enables Message to Click on “Finish” button

17. Product Configuration Completion Wizard Appears with successful completion of our selected product. Check once and hit on “Next”

18. 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“

2. 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).

3. The MySQL client displays the MySQL> prompt on successful login.

4. 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.

MySql 5.5.16 Database Installation

Download MySQL installer file

1. Download mysql-5.5.16-winx64.msi from this webpage link http://www.mysql.com/downloads/mysql/
2. 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 downloads! Link.
3. A list of sites from where you can download the MySQL file will be displayed.
4. Choose a ‘mirror’ which is closest to your geographical location to get the file fast. FYI, there is no problem in choosing a site located in Europe even though you are in the United States

Setting up MySQL

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

6. Click “Next” button in the introductory window

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

8. In the following screen, select Custom installation which will allow you to specify the folder to which MySQL will be installed. FYI, choosing Typical will put MySQL deep down in the “Program Files” folder.

9. Click the “Browse” button

10. And enter C:\MySQL in the Folder name field. Hit “OK” when done.

11. The installer will change the MySQL installation folder to the one specified by you – C:\MySQL

12. You are now ready to install MySQL on Windows 7 operating system. Click “Install”

13. It would take some time for the progress bar to start moving… be patient.

14. You may also get messages along the way – simply click on “Next” to proceed.

15. When the process finishes, you’ll get to see the final screen. Congratulations – MySQL has been installed on your computer. You are now prompted to Configure the MySQL server; click “Finish.

Configuring a MySQL instance

16. The MySQL Instance Configuration Wizard will now launch click “Next” to proceed. Please note that you cannot use MySQL until an instance has been configured, so these steps are quite important.

17. Select “Detailed Configuration” option

18. Choose “Developer Machine”

19. I suggest going ahead with “Multifunctional Database” unless you know what you are doing.

20. In the following screen, don’t mess with the default values and click “Next”.

21. The same goes for the subsequent screen; click “Next”

22. For the networking options configuration, put a check mark in front of “Enable Strict Mode” if it’s not there

23. Move ahead with the “Standard Character Set”

24. Yes, it’s recommended to install MySQL as a Windows service and have the system include the MySQL bin directory in the Windows PATH variable.

25. 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.    

      

26. The configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click “Execute” button

Ignore messages from the anti-virus program and answer in the affirmative when the Windows 7 UAC (User Account Control) asks whether you want to run MySQLInstanceConfig.exe file. Generally, the instance should be configured without any problem.
However, if the MySQL Instance Configuration Wizard becomes unresponsive (the window shows a ‘Not Responding’ message), launch the Task Manager either from the Control Panel or use the old Ctrl-Alt-Del key combination and kill the program. Now go to C:\MySQL\bin folder and double click on MySQLInstanceCOnfig.exe file to launch the wizard once again.

Checking the MySQL installation

27. 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.5“

28. 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)

29. The MySQL client displays the mysql> prompt on successful login.

30. 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.