MySQL Installation Guide on Windows 10

This tutorial is going to show you how to install MySQL Server on Windows 10. Did you know that you can turn your Windows 10 into a powerful MySQL Server? With few simple steps you can get MySQL running on your Windows 10. MySQL is a free, open source relational database system. This database server has been used by millions of users around the world. Please read the following MySQL Server Installation Guide on Windows 10 below. 

Before we go through, you will need to download the latest version of MySQL Community Server for Windows. Use the link we provided below to get started. 

MySQL Community Server 5.7.19 Free Download

MySQL Server Installation Guide on Windows 10

Step 1. Open the installer

You can choose to download the web installer or the complete installer. On this tutorial, I use the web installer version. To start the installation double click the installation file. It should looks like this

mysql-installer-web-community-5.7.19.0.msi

Step 2. Update existing MySQL products

In my case, I got an update notification. Click OK to start the update process. This will update the MySQL installer tool.

Once completed, the actual installer will start it’s job.

On the first wizard, click Next to proceed. The installer will detect any other MySQL program installed on your computer. 

In the next step, the installer will start downloading files required for the installation and updates. Please wait until this process is completed.

Step 3. Adding MySQL Server 

Now, we need to install MySQL Server using the MySQL Installer. Click Add button to add MySQL Server.

Add MySQL Server to the install list

Click Next

Click Execute to start the download process

It will start downloading files from the internet for MySQL installation. Wait until it completed. Once finished, the following window will appear. 

Step 5. Configure MySQL Server

This MySQL Installation Guide will continue to configure the MySQL Server. First we need to select whether it’s a Standalone MySQL Server/Classic MySQL Replication or a InnoDB Cluster Sandbox Test Setup. But the second one is for testing only.

Choose MySQL Type and Networking

We need to select the server configuration type for the MySQL Installation. You can choose config type such as Development machine, Server Machine and Dedicated Machine. In this example, I use the Development machine since I am going to use my computer for another purposes. You can read the differences between these config types from this link

Next, we need to specify the root password

You can also add user to the MySQL on this step. Next is to configure MySQL as Windows Service

Next we need to configure additional plugin

Now we are ready to install the server

In few moments, the installation is completed.

MySQL Server Installation Guide

Now our MySQL Server is ready. Thanks for reading this MySQL Server Installation Guide. 

1 Trackback / Pingback

  1. How to Backup MySQL Database using HeidiSQL in 3 Steps

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.