Download and Install MySQL

Download and Install MySQL on Windows Operating System

In this article, I am going to discuss How to Download and Install MySQL on Windows Operating System for development. Please read our previous article, where we gave a brief introduction to SQL.

Download MySQL

To download MySQL, please click on the below link:

https://downloads.mysql.com/archives/installer/

Once you click on the above link, it will open the below page. Select the Product Version, Operating System, and then click on the “Download” button as shown in the below image.

Download MySQL for Windows Operating System

Once the click on the download button, it will open the below page asking for login and signup. But if you want then you can skip this and just simply click on the No thanks, just start my download link as shown in the below image which will download the MySQL installer.

Download and Install MySQL on Windows Operating System

Install MySQL on Windows Operating System

Right-click on the installer and click Install as shown in the below image.

Install MySQL on Windows Operating System

Once you click on the Install option, it will open the MySQL Installer window as shown below and from this window, select the Full radio button and then click on the Next button as shown below.

MySQL Installer window

Once you click on the Next button, it might not be open the below Path Conflicts window. If MySQL already installed on your machine then you will get the below window. Here, simply click on the Next button as shown in the below image.

MySQL Path Conflicts window

Once you click on the Next button, it prompts one warning message as shown below. Simply click on the Yes option as shown in the below image.

Download and Install MySQL on Windows Operating System

Once you click on the Yes option, it will open the check requirements window. Here, simply click on the Next button as shown in the below image.

MySQL check requirements window

Once you click on the Next button, it will prompt one warning, simply click on the Yes option as shown in the below image.

How to Download and Install MySQL on Windows Operating System for development

Once you click on the Yes option, it will open the below Installation window, and from this window simply click on the Execute button as shown in the below image.

MySQL Installation window

Once you click on the Execute button, it will take some time to install the required resources. Once the Installation Completed, click on the Next button as shown in the below image.

How to Download and Install MySQL

Installation completed and once you click on the Next button, you will get the below Product Configuration window. Product Configuration means you need to set the username, password, port number, etc. So, here we have to configure the server and router. So, click on the Next button as shown below.

MySQL Product Configuration window

Once you click on the Next button it will open the below window. Here, you can select either Standalone MySQL Server or InnoDB cluster. Here, I am selecting Standalone MySQL Server and click on the Next button as shown in the below image.

Standalone MySQL Server or InnoDB cluster

Once you click on the Next button it will open the Type and Networking window. Here, you need to set the port number for the server and Config Type. Here, I am going with the default port number which is 3306 and the config type as Developer Computer, and finally, click on the Next button as shown in the below image.

MySQL Type and Networking window

Once you click on the Next button, it will open the Authentication Method window. The Authentication Method is basically used to set the username and password for your MySQL Server. Here, I am choosing Use Strong Password Encryption for Authentication option and click on the Next button as shown in the below image.

MySQL Authentication Method window

Once you click on the Next button, it will open the Accounts and Roles window. Here, you need to set the root password. Type root password and repeat the password and if you want then you can also add a new user by clicking the Add User button. I am not adding any new users at the moment. So, I simply set the root password and click on the Next button as shown in the below image.

MySQL Accounts and Roles window

Once you click on the Next button, it will open the Window Service window. This basically configures MySQL Server as a windows service. If you want then you can give a name to the window service but I am going with the default name i.e. MySQL80. Then specify how you want to run the service by selecting either Standard System Account or Custom Account. Here, I am going with the Standard System Account and finally click on the Next button as shown in the below image.

MySQL Window Service Window

Once you click on the Next button, it will open the below Apply Configuration window. Here, once you click on the Execute button, it will apply all the changes we have done so far. So, simply click on the Execute button as shown in the below image.

MySQL Apply Configuration Window

If everything working as expected, then all the configurations are applied and you get the following window and simply click on the Finish button.

How to Download and Install MySQL on Windows Operating System

Once you click on the Finish button, you will see that MySQL Server Configuration has been completed as shown below. Then similarly we need to configure MySQL Router and to do so, simply click on the Next button as shown in the below image.

MySQL Server Configuration

Once you click on the Next button, it will open the below MySQL Router configuration window. Now it is your call whether you want to configure the Router or not. As I am going to learn only MySQL and want to execute simple MySQL Command, so it is not required for me to install MySQL Router. So, I simply click on the Finish button as shown in the below image.

MySQL Router configuration Window

Once you click on the Finish button, it will take you to the Product Configuration window. Again you need to click on the Next button as shown in the below image.

MySQL Product Configuration Window

Once you click on the Next button, it will open the Connect to Server window. Enter the password which is you enter in the server configuration and click on the check button as shown in the below image. If you enter the correct password, then you will see the status as Connection Succeeded. Then click on the Next button as shown below.

MySQL Connect to Server Window

Once you click on the Next button, it will open the below Apply Configuration window. Simply click on the Execute button as shown in the below image.

Download and Install MySQL on Windows

Once the configurations are applied, then you will get the below window, and simply click on the Finish button as shown below.

Download and Install MySQL on Windows OS

Once you click on Finish, it will open the below window. Again, click on the Next button as shown in the below image.

Download and Install MySQL on Windows Operating System

Once you click on the Next button, it will open the below window. Simply click on the Finish button to complete the installation as shown in the below image.

How to Download and Install MySQL on Windows Operating System for development

That’s it. With this MySQL database as well as Workbench installed in your machine. Workbench is the tool using which we can interact with the MySQL database. In our upcoming articles, I will show you how to use Workbench to interact with the MySQL database.

Here, in this article, I try to explain How to download and install MySQL on Windows Operating System and I hope you enjoy this article. In the next article, I am going to give you an Overview of MySQL Database.

Leave a Reply

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