Follow the steps given below to download and set up MySQL on Windows 10: 
<ol>
<li><a href="https://dev.mysql.com/downloads/installer/">Click here</a> and download the (mysql-installer-community-8.0.23.0.msi) by clicking on the download button as shown in the below animation.</li>
</ol>
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif1.gif" alt="" />
&lt;|AD|&gt;
<ol start="2">
<li>Once the download completes, double click on the installer file.</li>
</ol>
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif2.gif" alt="" />
<ol start="3">
<li>Now, MySQL installer requires you to choose a set up type. You can install MySQL in five different types as listed below: </li>
</ol>
<ul>
<li>Developer Default : This module will install all the products you need for MSQL development purposes.</li>
<li>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.</li>
<li>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.</li>
<li>Full : If you select this module, then all the MySQL products and features will be installed on your computer.</li>
<li>Custom : Selecting this module allows you to manually select the MySQL products that should be installed on your computer.</li>
</ul>
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.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif3.gif" alt="" />
&lt;|AD|&gt;
Once you click on the next button after selecting the Full set up 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 connector requires Python version 3.7. Yon can install all the requirements easily otherwise simply click on Next button.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif4.gif" alt="" />
Now, you will be redirected to a installation window listing all the products that will be installed. Proceed further by clicking on the Execute &nbsp;button as shown in the below animation :
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif5.gif" alt="" />
&lt;|AD|&gt;
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.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif6.gif" alt="" />
Now, you will see a authentication window. Select &ldquo;Use Strong Password Encryption For Authentication&rdquo; and click on next. Enter your root password and then click on the next button.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif7.gif" alt="" />
&lt;|AD|&gt;
Now, you will see a &ldquo;Windows Service&rdquo;page. Check &ldquo;Start the MySQL Server at System Startup&rdquo; and click on next.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif8.gif" alt="" />
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.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif9.gif" alt="" />
&lt;|AD|&gt;
Again click on the Next button on the product configuration page and then click on the Finish button on the router configuration&nbsp; window.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif10.gif" alt="" />
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.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif11.gif" alt="" />
&lt;|AD|&gt;
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&nbsp; successfully installed on your computer.
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif12.gif" alt="" />
Testing :
<ol>
<li>Open MySQL command line client by searching MySQL in the search bar of Windows as shown in the below animation</li>
</ol>
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif13.gif" alt="" />
&lt;|AD|&gt;
<ol start="2">
<li>Type the password for root user and you see a welcome message then MySQL is successfully installed on your computer.</li>
</ol>
<img src="https://api.codewithharry.com/media/blogFiles/download-and-setup-MySQL/mySQL_gif14.gif" alt="" />
So, that&rsquo;s how you can easily install and setup MySQL database on Windows 10 operating system.

How to install and setup MySQL on Windows 10!

Add a new comment