How To Install MySQL On Windows 10

Introduction

 
MySQL is an open-source relational database management system (RDBMS). According to Wikipedia, "Its name is a combination of 'My', the name of co-founder Michael Widenius's daughter, and 'SQL', the abbreviation for Structured Query Language".
 
A relational database organizes data into one or more data tables that can connect data types to one another; these relationships help arrange the data. SQL is a language programmer for creating, modifying, and extracting data from the relational database, as well as managing user access to the database. In addition to relational databases and SQL, an RDBMS such as MySQL works with an operating system to incorporate a relational database in the storage structure of a computer, handles users, enables network access, and enable the checking of database consistency and backup creation.
 
MySQL is free and open-source software under the provisions of the GNU General Public License and is also licensed under a number of commercial licenses. As per Wikipedia, "MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation)".
 
What is the MySQL Installer?
 
With the support of the Wizard, MySQL Installer allows it easy to install MySQL. MySQL Installer offers a simple-to-use wizard to help users to install MySQL with the following elements:
  • MySQL Server
  • All Available Connectors
  • MySQL Workbench
  • MySQL Notifier
  • Tools for Excel and Microsoft Visual Studio
  • MySQL Sample Databases
In this tutorial, I have described various steps on how to install MySQL on Windows 10. This article covers the following topics:
  1. Download MySQL
  2. Install MySQL
  3. Connect to MySQL Server

Download MySQL

 
To download the MySQL, follow the below instructions carefully.
 
Step 1
 
To download the latest version of MySQL, visit the official website of MySQL in your web browser.
 
Step 2
 
Now, you have two options
 
1) When installing MySQL, if you are connected with the Internet, you should go with an online installation version "mysql-installer-web-community-8.0.21.0.msi".
 
2) If you want to install MySQL offline, you can download the "mysql-installer-community-8.0.21.0.msi".
 
installer
 
Now, I am going to download an online installation version.
 
Step 3
 
Now, you will be redirected to another page. Then, click on the "No thanks, just start my download" button to continue downloading.
 

Download MySQL

 
To download the MySQL, follow the below instruction carefully.
 
Step 1
 
Navigate to the MySQL Installer, double-click on it.
 
Step 2
 
Now, the installation wizard will appear on the screen, here you have to choose the setup type. Choose the "Full" option and then click on the "Next" button to proceed.
 
installer
 
Step 3
 
Here, the following products have failing requirements. Requirements mark as "Manual" cannot be resolved automatically. So, you can skip or either resolve them. And click on the "Next" button to proceed.
 
click on the Next button
 
Step 4
 
Now, click on the "Yes" button to continue.
 
click on the Yes button
 
Step 5
 
Click on the "Execute" button.
 
click on the Execute button
 
Step 6
 
Once the installation is completed click on the "Next" button.
 
click on the Next button
 
Step 7
 
Click on the "Next" button to continue.
 
click on the Next button
 
Step 8
 
Now, choose the default option, i.e. "Standalone MySQL Server" and click on the "Next button".
 
click on the Next button
 
Step 9
 
Here, leave the default options as it is, and click on the "Next" button.
 
click on the Next button
 
Step 10
 
Choose the authentication method as per your requirements, (here I am choosing the first option). And, click on the "Next" button to proceed.
 
click on the Next button
 
Step 11
 
Enter the MySQL Root Password and click on the "Next" button to proceed.
 
click on the Next button
 
Step 12
 
Leave the default option as it is and click on the "Next" button to continue.
 
click on the Next button
 
Step 13
 
Click on the "Execute" button.
 
click on the Execute button
 
Step 14
 
After the configuration process has completed, click on the "Finish" button.
 
click on the Finish button
 
Step 15
 
Click on the "Finish" button followed by the "Next" button.
 
click on the Finish button
 
Step 16
 
It's time to "Connect to the Server" by entering the root password. Then, click on the "Next" button to proceed.
 
click on the Next button
 
Step 17
 
Click on the "Execute" button to apply the changes.
 
click on the Execute button
 
Step 18
 
Click on the "Finish" button and your installation has been successfully completed.
 
click on the Finsh button
 
Congratulation! You have successfully installed the MySQL In your system.
 
click on the Finish button
 
To check whether MySQL is successfully installed or not, open the MySQL Command-Line and enter your root password.
 

Connect to MySQL SERVER

 
Now, open the MySQL Workbench which is the official GUI (Graphical User Interface) tool for MySQL, and let's execute our first query.
 
Workbench
 
Now, enter your root password and click on the "OK" button to proceed.
 
enter your root password and click on the OK button.
 
Type your first "create database" query and then execute it by pressing the "Ctrl + Shift + Enter" key. And your database has been created successfully.
 
Execute your query
 
Congratulations! We have successfully installed and connect our MySQL by using Workbench.
 

Conclusion

 
In this article, we have discussed various steps on how to install MySQL on Windows 10.
 
I hope you enjoyed this article. Follow C# Corner to learn more new and amazing things about MySQL.
 
Thanks for reading!