Sunday, 23 May 2021

How to Install MySQL in Windows Operating System

In this article, we will see How to install MySQL in Windows operating system step by step. MySQL is one of the popular open-source RDBMS (Relational database management system).


What is MySQL?

MySQL is one of the popular open-source RDBMS (Relational database management system). It is so used by many popular websites like Facebook, Twitter, YouTube, Flickr, etc. MySQL was owned and sponsored by the Swedish company, MySQL AB, which was brought by Sun Microsystems, now Sun Microsystem is acquired by Oracle Corporation.

Let’s begin:
Go to the official website of MySQL in order to download the MySQL Installer for Windows. You can also search for “MySQL Database Installation” in Google as shown in the below image. Click on the Download MySQL Installer link.
In MySQL Community Downloads, Choose the setup as per your system. I am downloading the mysql-installer-community-8.0.25.0.msi (Windows x86, 32 bit) setup file. Click on the Download button in order to download the MSI Installer.



MySQL msi installer will be downloaded in few minutes.
Double click on the downloaded installer file in order to start the installation.
In the next MySQL Installer screen, click on Add button. If some product already installed in your system, those will be shown in the grid.
Select the products you want to install in your system.
As you can see in the below image, I have selected MySQL Server, MySQL Workbench, Connector for .Net, Documentation, and examples. Click on Next to continue. You can select products as per your need.
Click on Execute button in order to install the selected products.
Once installation completed, click on Next in order to configure the installed products. In my case, I have to configure the MySQL Server & Sample and Examples.
In the next step, select the config type and other connectivity details. I selected config type as Development Computer as I need MySQL for development purpose. Selected TCP/IP with Port is 3306 and X Protocol Port value is 33060 (Keeping the default values) then Click on next button.
Select the Authentication method. I have selected the use of Strong Password Encryption for Authentication which is recommended.
Enter the password for the root account and Click on the Next button.
The next screen is about registering MySQL as Windows Service. Keep the selected values (default) as shown in the below image and then click on the Next Button.
Click on the Execute button in order to apply the configuration selected in above steps.
Once the configuration operation completed successfully, Click on the Finish button.
You can see that the Product Configuration completed. Click on the next button.
Select Start MySQL Workbench after setup and Start MySQL Shell after the setup in case you want to run just after Workbench and MySQL shell just after the installation. Click on the finish button.
As I have opted for the MySQL Workbench, it will open just after the completion of the setup. You can also run it from the start menu by searching MySQL Workbench. Click on the Local Instance (You can set up the new connection with the server details as well).
Provide the root password configured during the installation.
You can see the Sample & Examples are configured in the Schema. You can create your own new Database or Import the existing one.
I hope this article will help you in setting up MySQL in the windows operating system.
Thanks.


0 comments:

Post a Comment

Subscribe Now

Popular Posts

Contact us

Name

Email *

Message *

Subscribe us on YouTube

Like us on Facebook