How To Install MySQL on Windows 10? – Your One Stop Solution To Install MySQL

46 Views
2 / 4 Blog from Introduction To MySQL

MI-new-launch

myMock Interview Service for Real Tech Jobs

myMock-mobile-banner-bg

myMock Interview Service for Real Tech Jobs

  • Mock interview in latest tech domains i.e JAVA, AI, DEVOPS,etc
  • Get interviewed by leading tech experts
  • Real time assement report and video recording

There is no doubt in the fact that MySQL is one of the most popular relational database systems. This article is going to be a brief guide on How to install MySQL, for beginners.

MySQL is a database management system that is used extensively in today’s industry. It comes with multi-user access to support many storage engines and is backed by Oracle.

So, if you follow these few simple steps, you should be able to download and install MySQL on your Operating Systems, completely hassle-free.

Now, to install MySQL, there are mainly three factors you must consider:

  1. Operating System
  2. What to use to install MySQL?
  3. Features you wish to install

In this article, I am going to install MySQL on Windows using the MySQL Installer.

What is MySQL Installer?

MySQL Installer makes it easy to install MySQL with the help of the wizard. Once you finish installing MySQL, you will see various other features installed, such as MySQL Server, MySQL Workbench, MySQL Shell and so on.

Now, let us get started with the installation of MySQL.

Installation of MySQL – MySQL Installer

Step 1: Go to the official website of MySQL and scroll down. Then you will see an option to choose the Operating System. Here I will choose Windows.

Step 2: After that, you will see two options to Download. If you have internet connectivity then you can go forward and choose the mysql-installer-web-community, else you can choose the other one. Refer below.

Choose Operating System - Install MySQL - Edureka

Step 3: Once, you click on Download, you will be redirected to the following page:

Download - Install MySQL - Edureka

In the above page, just click on the option of “No thanks, just start my download.” Once, you click on this option, you will see that MySQL Installer is getting downloaded.

Step 4: After MySQL Installer gets downloaded, double click on it, and you will see that the MySQL installer Community is getting installed. Once, it is downloaded you will see the following screen.

License Wizard - Install MySQL - Edureka

In the above dialog box, just check in in the radio button and accept the License Agreement. After that, click on Next.

Step 5: In the next wizard, you have to choose the setup type. Basically, this is where you choose which features you wish to install. Here I will choose the option Full and click on Next.

Choose Setup Type - Install MySQL - Edureka

This option will MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more.

Step 6: Once you click on Next, you might see that some features may fail to install due to lack of requirements. So, either you can resolve them, or can skip them, by clicking on Next. Here I will click on Next.

Check Requirements - Install MySQL - Edureka

Step 6.1: 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. Refer below.

Not Install Few Products - Install MySQL - Edureka

As soon as you click on Next, you will see the list of the products which will get installed. So, if you are fine with the products, go ahead and click on Execute as below.

Once you hit on Execute, you will see that the products are getting installed. Refer below:

Now, once the installation is complete, click on Next.

Finish Installing - Install MySQL - Edureka

Server Configuration

Next, you have to configure the Server and Router. Well, over here let me tell you that, I am not going to configure the Router now since it is not required to simply use MySQL. But, I will show you how to configure Server. So, in the below dialog box, click on Next.

Product Configuration - Install MySQL - Edureka

Step 7: In the below wizard, you can either choose the Standalone MySQL Replication or the InnoDB Cluster based on your requirement. Here I will choose, Standalone MySQL Cluster and then click on Next.

Standalone MySQL Server - Install MySQL - Edureka

Step 8: Once, you click on Next, you have to mention the server configuration. So, I will leave it as it is and then click on Next.

Type and Networking - Install MySQL - Edureka

Step 9: Now, you have to choose the authentication method. Here, I will choose the first option and click on Next. Refer below.

Authentication Method - Install MySQL - Edureka

Step 10:   Next, you have to mention the MySQL Root Password and again click on Next.

Mention Root Password- Install MySQL - EdurekaNOTE: Please make a note of this password.

Step 11: Finally, you have to choose whether you want to start the server or not. Here, I am going to leave it as it is. Then, click on Next.

Configure - Install MySQL - Edureka

Now, the wizard will give you a list of the configurations which will be applied. So, if you agree with the configuration click on Execute.

Apply Configuration - Install MySQL - Edureka

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

Configuration Applied - Install MySQL - Edureka

Step 12: In the next wizard that comes up, you can choose to configure the Router. So just click on Next and click on Finish.

Router Configuration - Install MySQL - Edureka

Step 13: Once, you click on Finish, you will see the following wizard, to Connect to server. Here mention the root password, which you had set in the previous steps. Refer below.

Check Router Password - Install MySQL - Edureka

Check if the connection is successful, by clicking on the Check button and then click on Execute. Now, once the configuration is complete click on Next.

Step 14: Once, you click on Next, choose the configurations applied and click on Execute.

Apply Configurations - Install MySQL - Edureka

After the configurations get applied, you will see the following screen. So, here just click on Finish. Refer below.

Installation Complete - Install MySQL - Edureka

Check Whether MySQL Is Installed Or Not 

Step 15: Now, to check whether MySQL is installed or not, you can open the MySQL Shell and mention the root password.

MySQL Command Client - Install MySQL - Edureka

The above output indicates that MySQL has been installed in your system. Now, that you know how to install MySQL if you wish to know about the GUI of MySQL, you can refer to my article on MySQL Workbench.

If you wish to learn more about MySQL and get to know this open source relational database, then check out our MySQL DBA Certification Training which comes with instructor-led live training and real-life project experience. This training will help you understand MySQL in depth and help you achieve mastery over the subject.

Got a question for us? Please mention it in the comments section of ”How To Install MySQL?” and I will get back to you.

Comments
0 Comments

Browse Categories

Subscribe to our Newsletter, and get personalized recommendations.