Without a question, MySQL is one of the most widely used relational database systems. Every database industry makes significant use of the database management system MySQL. It is run by Oracle Corporation and offers a multi-user access to support multiple storage engines.

Here, we’ll use MySQL Installer to set up MySQL on Windows.

Before starting with MySQL Installer, you need to know what MySQL installer is.

The wizard in the MySQL Installer makes it simple to install MySQL. Several other features, including MySQL Server, MySQL Workbench, MySQL Shell, and others, will be installed after you have finished installing MySQL.

Let’s get started-

  • Installation of MySQL – MySQL Installer

Step 1: At first you need to go to the official website of MySQL(mysql.com) and scroll down. You will see an option to select Operating System.
You need to choose Microsoft Windows.

Step 2: Then you will see two options to download. You can select one of them or you can take a reference from the below image.

MySQL Step 2

Master SQL concepts in depth from this SQL Tutorial now!

Step 3: Once you click on the download option, you will be redirected to the next page and you will have to click on the “No thanks, just start my download” option.
After that, you will see that MySQL Installer is getting downloaded.

MySQL Step 3

Step 4: Once, MySQL Installer gets downloaded, you need to open that and you will see that the MySQL installer Community is getting installed.

Then you will see the following screen. Next, all you need to do is to click on the radio button which is asking for the acceptance of the license terms. After that, click on Next.

MYSQL Step 4

Step 5: In the next process, you have to choose the setup type.

This means that you have to choose which features you wish to install. So, choose the Full button and click on Next.

This process installs all of the products that are available in this catalog including MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples, and much more.

MYSQL Step 5

Step 6: In the next step, you will see that some of the features may fail to install due to a lack of requirements.

So, either you can fix them, or can skip them, by clicking on Next as it willn’t interrupt the installation process.

So, click on Next.

MYSQL Step 6

Next, you will see a dialog box asking for your confirmation of a few products not getting installed.

So, you can just click on Yes.

dialog box asking

Next, you will see the list of the products which will get installed.

So you can go ahead and click on the Execute option, which we highlighted in the below image.

Execute option

After clicking on the Execute option, you will see that the products are getting installed.

Once the installation process shows complete, click on Next.

installation process

Next, you have to configure the Server and Router. After that click on Next.

Server and Router

Preparing for job interviews? Have a look at our SQL Server interview questions and answers now!

Step 7: Based on your requirement, you can either choose the Standalone MySQL Server/ Classic MySQL Replication or the InnoDB Cluster.
We clicked on the Standalone MySQL Server/ Classic MySQL Replication option and then click on Next.

Standalone MySQL

Reach out to our course advisors and enroll in Intellipaat’s MS SQL course.

Step 8: Once, you click on Next, you will get the Type and Networking page where you have to mention the Server Configuration Type.

We left it as it is and then click on Next, you can take reference from the below image.

Step 8 MYSQL

Step 9: Now, you will get to the Authentication Method page where you have to choose the authentication mode.

Here, you can choose the first option as given in the below image, and click on Next.

Step 9 MYSQL

Step 10: Next, you have to make the MySQL Root Password and then repeat the same password and then click on Next.

  • Remember the password that you have mentioned or you can take note of that password for the future.

Step 10 MYSQL

Step 11: After that, you will get the Windows Service page where you have to choose whether you want to start the MySQL Server at system startup or not. Here, we are keeping it as it is and has not changed anything.

Click on Next.

Step 11 MYSQL

After clicking on Next, you will get the Apply Configuration page where you will get a list of the configurations that you want to execute to apply the changes from the list of these configurations.

So, if you agree with these configurations click on Execute.

click on Execute

After the execution is done, click on Finish. This will finish the configuration of the Server.

Step 12: On the next page you can choose to configure the Router.
So click on click on Finish.

Step 12 MYSQL

Step 13: Once, you click on Finish, you will see the Connect to server page.

Here you have to give the root password, which you set earlier.

Now, you have to check if the connection is successful, by clicking on the Check button.

Then after the configuration is completed, click on Next.

Step 13 MYSQL

Step 14: After clicking on Next, you will get the Apply Configuration page, where you can choose the configurations that are applied and then click on Execute.

Step 14 MYSQL

Step 15: In the next step, you will see the screen which is given below.
After the configurations get applied, click on Finish.

Here, you can check on the page that the installation procedure has been completed.

mySQL Step 15

Step 16: After completing all of the above steps and procedures, you can finally check if MySQL has been installed or not.

Now you just have to open MySQL Shell and fill in your root password.

Step 16 MYSQL

The above output shows that MySQL has been installed in your system.

Visit our SQL Community to get answers to all your queries!

Course Schedule

Name Date Details
SQL Training 11 Feb 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 18 Feb 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 25 Feb 2023(Sat-Sun) Weekend Batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *