Install Mysql on Windows 10 Step by Step

By | 2018-11-11T10:30:55+00:00 September 2nd, 2018|mysql|0 Comments

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 own credentials, you can login or else if you wish to sign up now you can click on green colored signup button.

If you are not interested in login or sign up for now, you can simply 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:

The windows configure the installer, in 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 simply 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 configure the server in two different modes. One is standalone mode and another one is clustered 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 own port you can simply change here itself and click on Next. For now, I am leaving as it default configuration.

Install MySql on Windows 10 -16

Step 15:

It is prompting you to select the authentication method, leave it as 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 colored 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 open and ask your root password, give your password and press enter. Then you can 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 giving show databases command.

Install MySql on Windows 24

We are completely done with our installation process.

Happy Learning 🙂

About the Author:

Hi Folks, you have reach this so far, that shows you like what you are learning. Then why don't you support us to improve for bettor tutorials by leaving your valuable comments and why not you keep in touch with us for latest updates on your favorite blog @ facebook , twitter , Or Google+ ,

Leave A Comment