In this tutorials, I am going to show how to install Mysql on Windows 10 operating system.

Install Mysql on Windows 10:

I hope this step by step process to install Mysql on Windows 10 will help you better.

Version Information:

  • Windows 10 Pro
  • Mysql Community Server 8.0.12

Step 1:

Download the latest Mysql Community server from MySQL official website. For me, it is 8.0.12, if the version differs you no problem the installation steps will be the same.

By clicking on the above URL, you will see the below options. Select your operating system (Microsoft Windows) and click on Go to Download Page. It will redirect you the actual download page for windows Mysql server.

Install MySql on Windows 10 -1

Step 2: 

It will show you Generally Available (GA) Releases. Where we can see two different installers, one is a web community installer which comes as a little file and another one is MySQL installer community. Click the Download button on the second one (mysql-installer-community).

Install MySql on Windows 10 -2

Step 3:

It will ask your MySQL credentials to download the .msi file. If you have your credentials, you can log in or else if you wish to sign up now you can click on the green coloured signup button.

If you are not interested in login or sign up for now, you can directly go and click on No thanks, just start my download option. It will download selected MySQL for you on your local machine.

Install MySql on Windows 10 -3

Step 4:

Go to your downloads folder where you can see the mysql-installer-community file, right click on that file and click Install option.

Install MySql on Windows 10 -4

Step 5:

This window configures the installer, in the middle, it may ask you for permissions to change your computer settings or firewall confirmation, you can accept and then it will take a few seconds to configure the installer.

Install MySql on Windows 10 -6

Step 6:

Read the license agreement and accept the license terms.

Install MySql on Windows 10 -7

Step 7:

This window provides you to set up different types of MySQL installations. You can set up Mysql in 5 different types as provided below. Now I am selecting the Developer Default as I am a developer so that I need all the products which help my development purposes. Click on Next.

Install MySql on Windows 10 -8

Step 8:

Based on your Windows configuration, it may prompt you like “One or more product requirements have not been satisfied”. You can just click on YES.

Install MySql on Windows 10 -9

Step 9:

Click on Execute.

Install MySql on Windows 10 -10

Step 10:

Upon execution of the previous step, the installer grasps all recommended products in place and asking for our approval to execute the product installation process. Click on Execute.

Install MySql on Windows 10 -12

Step 11:

Upon successful execution of all required products, now the MySQL allows us to configure the server settings. Click on Next to configure the server.

Install MySql on Windows 10 -14

Step 12:

This step allows you to configure the server. We can set the server in two different modes. One is a standalone mode, and another one is cluster mode. I don’t want to make it as a cluster because I am installing MySQL for development purpose so that I am selecting Standalone MySQL server and click on Next.

Install MySql on Windows 10 -15

Step 14:

Choose the Development Computer option from Config Type drop-down. You can find the following controls like TCP/IP, Port and X Protocol Port. If you wish to configure your port, you can change here itself and click on Next. For now, I am leaving as its default configuration.

Install MySql on Windows 10 -16

Step 15:

It is prompting you to select the authentication method, leave it as the default recommended method and click on Next.

Install MySql on Windows 10 -17

Step 16:

Here you can set your MySQL root user password. If you wish to create a new user, you can click on Add User button under MySQL user accounts section.

Install MySql on Windows 10 -18

Step 17:

Upon clicking on Add User button, you will get the user details popup which allows you to create a new user account. After creating the user click on Next.

Install MySql on Windows 10 -19

Step 18:

Leave the service details as default and click on Next.

Install MySql on Windows 10 -20

Step 19:

Press Execute to apply the configurations on the previous step.

Install MySql on Windows 10 -21

Step 20:

Upon execution, you can see the below green coloured ticks on every configuration option and finally you will get Finish button.

Install MySql on Windows 10 -22

Click on Finish you got your MySQL on your Windows 10 operating system.

Testing:

Search for MySQL in your taskbar search item. There you can see all MySQL products which we installed and click on MySQL client; it will ask your MySQL password to login, after successful login you could see the MySQL prompt like below.

Install MySql on Windows 10 -23

MySQL comes along with some default databases. We can see the databases by using show databases command.

Install MySql on Windows 24

We are completely done with the installation process, so now let’s create a table in it.

Happy Learning 🙂

34 Comments

  1. laptop won't charge November 20, 2018 at 3:20 pm - Reply

    Good post….thanks for sharing.. very useful for me I will bookmark this for my future needs. Thanks.

  2. Namrata Gowda May 23, 2019 at 7:20 pm - Reply

    Thank you so much. This article is very short and to the point. Saved a lot of time.

  3. Javed June 14, 2019 at 2:22 pm - Reply

    can you please provide step by step solution for configuring multiple instances on same machine of mysql 8.0 on windows 10

  4. Max June 20, 2019 at 8:50 pm - Reply

    After step 8 nothing works – it only installs connectors. Does not install server or nothing else. Win 10 problem?

    • Dimi August 20, 2019 at 2:10 pm - Reply

      Hi,

      probably you are missing the Microsoft 2015 Redistributable Package x64.

      If check closely it is written in a second column, as requirements for every product to be installed.

  5. Rohan Singh July 18, 2019 at 11:24 am - Reply

    Very useful, thanks for it

  6. Mohammed Faisal Madani August 14, 2019 at 4:49 pm - Reply

    Thanks it was very useful and the points were clear cut was easy to install thanks again appreciate your efforts sir.

  7. Pramod August 18, 2019 at 1:11 am - Reply

    Thank you for sharing was useful.

  8. Jack Liu September 5, 2019 at 6:23 pm - Reply

    Thank you for sharing such nice post, but in the test you need press ; at end of line,it’s a little flaw about this post.
    My English is bad, sorry about it.

  9. Mozahar Ahmed September 5, 2019 at 6:30 pm - Reply

    This Step by step approach makes things easy. You missed the last step? or it added recently? I am not sure but it is not a big deal.
    Thanks for your effort.

  10. a September 16, 2019 at 2:51 am - Reply

    Thnks
    Good job

  11. Syed October 6, 2019 at 6:55 pm - Reply

    Thanks for sharing the details.. i can install it ..

  12. chenni May 14, 2020 at 2:10 pm - Reply

    thanks

    • SHABEER.H November 8, 2020 at 12:42 pm - Reply

      Thanks 🙏🙏

  13. Vidya May 25, 2020 at 10:59 pm - Reply

    Previously i had once installed mysql..but i forgot my password..so i installed it.
    Now i am installing it again..and it is asking for that previous password only… what to do..?

  14. Infinity July 25, 2020 at 9:29 am - Reply

    Very helpful Article to student ..

  15. Rajesh Kumar August 5, 2020 at 10:25 am - Reply

    Thanks Sir . It was very useful and the points were clear cut was easy to install thanks again appreciate your efforts sir.

  16. Rajendra Kumar Sahu August 9, 2020 at 1:29 am - Reply

    Thank you Sir! This post on guide to install mysql is perfectly helpful for others. Thank you very much for sharing such information with us.

  17. swapna August 11, 2020 at 12:48 pm - Reply

    Thank you so much.Very easy to follow

  18. Lakshmi Narayanan K September 5, 2020 at 3:44 pm - Reply

    Thanks for the help. installed the sql without any issues.. Your work is highly appreciated:)

  19. Pinky September 12, 2020 at 12:58 pm - Reply

    This article was very helpful. Thank you very much.

  20. Venj October 8, 2020 at 5:23 am - Reply

    Thank you so much! :))

  21. chethan October 9, 2020 at 12:38 pm - Reply

    Thank you sir ! it was very useful ..

  22. Devika October 10, 2020 at 2:13 pm - Reply

    Thanks a lot , it save me lot of time.

  23. Pit November 17, 2020 at 4:01 pm - Reply

    Thank you, managed to install it smoothly!

  24. nuiping December 22, 2020 at 9:10 am - Reply

    thanks a lot 100%

  25. ID January 27, 2021 at 6:23 pm - Reply

    When I try to install it does not give the option of License agreement in the installer. What can be done?

  26. Saiful Alam February 11, 2021 at 9:32 pm - Reply

    Thank you so much. This article is very help full, short and to the point. Saved a lot of time.

  27. Vrushti March 1, 2021 at 2:52 pm - Reply

    I am having trouble after the 6th step. The license agreement option is not showing up. what do I do?

  28. caironisa March 20, 2021 at 3:23 pm - Reply

    Thank you!!!! It helped me a lot ^.^

  29. Anila Kumar Panda April 13, 2021 at 3:28 pm - Reply

    Thanks a lot for sharing this helpful document.

  30. meenakshi May 2, 2021 at 5:16 pm - Reply

    Thank you so much, it helped me a lot.

  31. hithesh pl May 29, 2021 at 11:43 pm - Reply

    Nice it’s useful..bt please new steps because this version has some new steps included in that

  32. Abhishek July 23, 2021 at 3:05 pm - Reply

    Nice post the steps given are some what modified but the the overall procedure was same for me , thanks

Leave A Comment