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:

Download MySQL
Install MySQL
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".

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.

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.

Step 4

Now, click on the "Yes" button to continue.

Step 5

Click on the "Execute" button.

Step 6

Once the installation is completed click on the "Next" button.

Step 7

Click on the "Next" button to continue.

Step 8

Now, choose the default option, i.e. "Standalone MySQL Server" and click on the "Next button".

Step 9

Here, leave the default options as it is, and 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.

Step 11

Enter the MySQL Root Password and click on the "Next" button to proceed.

Step 12

Leave the default option as it is and click on the "Next" button to continue.

Step 13

Click on the "Execute" button.

Step 14

After the configuration process has completed, click on the "Finish" button.

Step 15

Click on the "Finish" button followed by the "Next" button.

Step 16

It's time to "Connect to the Server" by entering the root password. Then, click on the "Next" button to proceed.

Step 17

Click on the "Execute" button to apply the changes.

Step 18

Click on the "Finish" button and your installation has been successfully completed.

Congratulation! You have successfully installed the MySQL In your system.

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.

Now, enter your root password and click on the "OK" button to proceed.

Type your first "create database" query and then execute it by pressing the "Ctrl + Shift + Enter" key. And your database has been created successfully.

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!