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 🙂

About the Author:

Avatar
Founder of onlinetutorialspoint.com Love Java, Python, Shell and opensource frameworks. Follow him on twitter and facebook for latest updates.

32 Comments

  1. Avatar
    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. Avatar
    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. Avatar
    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. Avatar
    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?

    • Avatar
      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. Avatar
    Rohan Singh July 18, 2019 at 11:24 am - Reply

    Very useful, thanks for it

  6. Avatar
    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. Avatar
    Pramod August 18, 2019 at 1:11 am - Reply

    Thank you for sharing was useful.

  8. Avatar
    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. Avatar
    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. Avatar
    a September 16, 2019 at 2:51 am - Reply

    Thnks
    Good job

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

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

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

    thanks

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

      Thanks 🙏🙏

  13. Avatar
    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. Avatar
    Infinity July 25, 2020 at 9:29 am - Reply

    Very helpful Article to student ..

  15. Avatar
    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. Avatar
    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. Avatar
    swapna August 11, 2020 at 12:48 pm - Reply

    Thank you so much.Very easy to follow

  18. Avatar
    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. Avatar
    Pinky September 12, 2020 at 12:58 pm - Reply

    This article was very helpful. Thank you very much.

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

    Thank you so much! :))

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

    Thank you sir ! it was very useful ..

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

    Thanks a lot , it save me lot of time.

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

    Thank you, managed to install it smoothly!

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

    thanks a lot 100%

  25. Avatar
    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. Avatar
    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. Avatar
    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. Avatar
    caironisa March 20, 2021 at 3:23 pm - Reply

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

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

    Thanks a lot for sharing this helpful document.

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

    Thank you so much, it helped me a lot.

Leave A Comment