How to install MySQL Server on Windows 10

This guide will show you how to install MySQL Server on Windows 10. I am using Windows 10 64 bit and MySQL Server version 5.7.11. You can download MySQL Server 5.7.11 from the Official MySQL Download page. I choose the MySQL Installer Community which is about 378 MB in size. This package includes all packages and drivers needed to run MySQL Server on a Windows machine.

To start the install process, double click the fileĀ mysql-installer-community-5.7.11.0.exe. A new window will come up and offers you some options. You may want to install or upgrade your MySQL Workbench installation (if you have any previous version installed), ODBC Drivers and some others.

install mysql on windows 10 step 1.png

Now click Add to add more apps or features to install

install mysql on windows 10 step 2

On this example, I want to install MySQ Server, MySQL for Excel and also I want to install MySQL Documentation. You can change this with your own setup.

install mysql on windows 10 step 3.png

Press Next to confirm your selection and the installation process will take place. When completed, you should see the following window on your Desktop.

install mysql on windows 10 step 4

You will be directed to the next step, time to configure MySQL

install mysql on windows 10 step 5

Press Next on above window to start configuring MySQL Server. On the config window, you will need to specify the config type. There are three different setup: Development Machine, Server Machine and Dedicated Machine. Also you can specify the connectivity to your MySQL Server.

install mysql on windows 10 step 6.png

Next, you will need to specify root password for MySQL Server.

install mysql on windows 10 step 7

Additionally, you can add new MySQL users if you want. To add new MySQL user, click Add User and provide password for the new user.

install mysql on windows 10 step 8

Press Next and we need to configure MySQL Service. Leave the default value if you don’t have any idea on this section.

install mysql on windows 10 step 9

Finally, press Execute to complete the installation

install mysql on windows 10 step 10.png

Now your new MySQL Server is ready to use.

Thank you for reading this post on How to install MySQL Server on Windows 10. Please leave us comments if there are any questions.

Admin

Leave a Reply

Your email address will not be published. Required fields are marked *