How to Install MySQL on Windows?
The following article provides an outline for How To Install MySQL. MySQL is a relational database system, and the best part is, it is open source and absolutely free. It is developed by “Michael Widenius” and their team. Now it is maintained by Oracle Corporation.
Steps To Install MySQL on Windows
Given below are the steps to install MySQL on windows:
Step 1: First, you need to visit this site: https://dev.mysql.com/downloads/ to download and install MySQL in your local system. When you landed on this page, just find MySQL Community Edition(GPL) and click on the download button.
Step 2: It redirects you to another page; just scroll down and find the Generally Available(GA) Releases section and click the dropdown and select the operating system. By default, Microsoft Windows is selected, and you can choose other OS as well by click on the dropdown menu shown below.
Step 3: Just scroll down and click on “Go to Download Page,” which is circled in red color below. Please don’t download from the other Downloads section, which is available exactly below the “Go to Download Page” option.
Step 4: After click on “Go to Download Page,” it redirects you to another page where you need to click 2nd option, Windows (X86, 32-bit), MSI Installer, which has 324.3 MB of size and circled in red below. 1st download option, which has 16.4 MB size, is a web-based installer that is a launcher file to install MySQL, so avoid 1st option.
Step 5: When you click on the download button, it redirects you to another page where it has three options. First Login if you already have account with Oracle, then use this otherwise, click on the Sign up button and fill necessary details of yours. The third option allows you to download without a login so you need to click on “No thanks, Just Start my download,” which is marked in red in the below screenshot. It will start to download.
Step 6: When the download is finished then click on the downloaded file. It will start installing, and then you will get a window. Just press Yes and continue.
Step 7: Now click on the checkbox near “I accept the license terms” indicated in the red square and click on the next button.
Step 8: Select the Developer Default option and click on the Next Button as shown.
Step 9: Then again, click on Next in the Check Requirements window.
Step 10: After this, it shows one warning message, so need to click on Yes and proceed.
Step 11: Then Click on the Execute button.
Step 12: It will take some time to execute and install above all and just check the status for all products when it shows complete then click on the Next button.
Step 13: Again Click Next in the Product Configuration window.
Step 14: Select Standalone MySQL Server/ Classic MySQL Replication and click on Next Button in Group Replication window.
Step 15: Click Next in the Type and Networking window, please don’t make any changes there, leave as it is.
Step 16: Select Use Strong Password Encryption for the authentication option and click on the Next button.
Step 17: Type MySQL Root Password and Retype the password and click on Next Button. You need to set a password that you can always use when you want to open MySQL.
Step 18: Click on the Next button.
Step 19: Click on the Execute button.
Step 20: Click on Finish Button.
Step 21: Click Next on the product configuration page.
Step 22: In user name keep root by default as user and type password which you set earlier. Click on Next. It will test they are able to connect the server or not and it will check the installation has been completed successfully or not.
Step 23: For a few systems it requires few more steps to configure other installation which supports the MySQL. In that condition, you need just click on the Next and Execute button please avoid making any changes. Few systems will automatically configure settings so need not to worry. Now finally click on the finish button.
Step 24: It completes the Installation of MySQL and opens the MYSQL shell and MySQL Workbench. Please close both and restart your system.
Step 25: First go to Start in windows and search MySQL it will show multiples file related to MySQL but you need to find only MY SQL Command Line Client and MySQL Workbench. Both options come with their respective version like I have downloaded the MY SQL 8.0 Command Line Client, So it shows to me the respective version. It may differ user to user and version to version but the steps would be the same. Please click on MY SQL Command Line Client shown below.
Step 26: It will open the MySQL Command prompt and ask you to give your root password which you gave while installing MySQL. The type that password and press enter. After authentication, it starts with mysql> shown below.
Step 27: Check MySQL is working or not so just please check how many databases it has.
Show databases:
It will show all available databases with MySQL which is displayed below. It means everything is working fine.
It shows it has 6 databases available here. i.e information_Schema, mysql.
Step 28: If you want to close the MySQL then please type the exit command as below, it will close the MySQL.
Recommended Articles
This has been a guide to how to install MySQL on windows. Here we have discussed the instructions and steps to install MySQL. You can also look at the following article to learn more –
