How to install and setup MySQL on Windows 10!

Follow the steps given below to download and set up MySQL on Windows 10:

1. Click here and download the mysql-installer-community-8.0.23.0.msi by clicking on the download button as shown in the below animation.

   

2. Once the download completes, double click on the installer file.

   

3. Now, MySQL installer requires you to choose a setup type. You can install MySQL in five different types as listed below:

   • Developer Default: This module will install all the products you need for MySQL development purposes.
   • Server Only: If you select this module, then only the MySQL server will be installed on your computer. If you only want to deploy a MySQL server, then this module is for you.
   • Client Only: This module contains tools required for MySQL application development except the MySQL server. So, if you want to develop applications for an existing server, then you need to download this module.
   • Full: If you select this module, then all the MySQL products and features will be installed on your computer.
   • Custom: Selecting this module allows you to manually select the MySQL products that should be installed on your computer.

   I will be selecting the Full option as I want to install all the features of MySQL. If you are installing MySQL for the first time, then I would recommend you to proceed further by selecting the Full option.

   

Once you click on the next button after selecting the Full setup type, MySQL requires you to check the requirements. In the below animation, you can see that MySQL for Visual Studio Code requires Visual Studio version 2015, 2017 and the connector requires Python version 3.7. You can install all the requirements easily, otherwise simply click on Next button.

Now, you will be redirected to an installation window listing all the products that will be installed. Proceed further by clicking on the Execute button as shown in the below animation:

Click on the next button once all the products are downloaded successfully. You will now see a Type and Networking Window which requires you to select the port number and config type. You can change the port number if you want, otherwise click on Next button to proceed with default settings.

Now, you will see an authentication window. Select “Use Strong Password Encryption For Authentication” and click on next. Enter your root password and then click on the next button.

Now, you will see a “Windows Service” page. Check “Start the MySQL Server at System Startup” and click on next.

After this, MySQL requires you to apply configurations. Click on the Execute button and wait until all the configurations are executed. Click on the Finish button once all the configurations are applied.

Again click on the Next button on the product configuration page and then click on the Finish button on the router configuration window.

After this, you need to enter the root password to connect to the server. Click on the Check button and if you see the status as Connection succeeded then click on the Next button.

Now, click on the Execute button to apply configuration. Click on the Finish button once the configurations are applied. Again, click on the finish button and MySQL is successfully installed on your computer.

Testing:

1. Open MySQL command line client by searching MySQL in the search bar of Windows as shown in the below animation.

   

2. Type the password for root user and if you see a welcome message, then MySQL is successfully installed on your computer.

   

So, that’s how you can easily install and set up MySQL database on Windows 10 operating system.