Back to: MySQL Tutorials for Beginners and Professionals
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.
How to 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.
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.
How to Install MySQL on Windows Operating System
Right-click on the installer and click Install as shown in the below image.
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.
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.
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.
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.
Once you click on the Next button, it will prompt one warning, simply click on the Yes option as shown in the below image.
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.
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.
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.
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.
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.
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.
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.
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.
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.
If everything working as expected, then all the configurations are applied and you get the following window and simply click on the Finish button.
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.
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, it is not required for me to install MySQL Router. So, I simply click on the Finish button as shown in the below image.
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.
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.
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.
Once the configurations are applied, then you will get the below window, and simply click on the Finish button as shown below.
Once you click on Finish, it will open the below window. Again, click on the Next button as shown in the below image.
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.
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 How to download and install MySQL on Windows Operating System article. In the next article, I am going to give you an Overview of MySQL Database.
About the Author: Pranaya Rout
Pranaya Rout has published more than 3,000 articles in his 11-year career. Pranaya Rout has very good experience with Microsoft Technologies, Including C#, VB, ASP.NET MVC, ASP.NET Web API, EF, EF Core, ADO.NET, LINQ, SQL Server, MYSQL, Oracle, ASP.NET Core, Cloud Computing, Microservices, Design Patterns and still learning new technologies.