How To Install MySQL In Windows 10

By Tech-Act    
05/07/2021  1589 Views

How To Install MySQL In Windows 10

Introduction to MySQL:

  • Do you know how My SQL name was formed? Well, if you look at it carefully it is a combination of two names i.e. “My” it is the name of the co-founder Michael Widenius’s daughter and “SQL” is the full form of Structured Query Language. MySQL is one of the most popular open-source database management systems. It is easy to use, reliable, and fast. MySQL is a database management system that works on embedded systems as well as client-server systems.
  • Have you thought what makes MySQL so popular? MySQL is an open-source. It is used at a large scale hence a lot of code is readily available. Entire developed systems are also available which can be referred for the future projects. MySQL has relational databases therefore methodical storage is possible. It is also quick and robust.

What is the MySQL Installer?


  • MySQL installer can be easily installed if it is supported by the Wizard.
  • A simple to use wizard is provided by MySQL which aids the users to install MySQL with the elements like MySQL Server, All Available Connectors, MySQL Workbench, MySQL Notifier, Tools for excel and Microsoft visual Studio, MySQL Sample Databases.

Source

Today, in this article we have explained in detail how to install MySQL in windows 10. Here are the various steps required for installing MySQL on Windows 10.


Step 1


  • The first step is to download the latest MySQL community server from the official website of MySQL. The version at my end is 8.0.12, but even if the version is different for you still the installation process will be same.
  • By visiting the above mentioned website, you will see the options. Then, you have to select the OS as Microsoft windows and click on Go to Download page.
  • This will take you to the actual download page for windows MySQL server.

Step 2


  • Generally Available Releases will be displayed, and then you would be able to see two different installers i.e. Web community installer & MySQL installer community. Select MySQL installer community.

Step 3


  • Then MySQL credentials will be asked to download the .msi file. If your credentials are available then you can simply log in or if you want to sign up then go to green colored signup button and click it.
  • You also have the option to skip this step of login & signup by directly clicking on No thanks, just start my download option. And the downloading will begin on your local machine.

Step 4


  • Visit the download folder where mysql-installer-community file is visible and then right click on that file and select install option.

Step 5


  • The windows will begin the configuration process and while doing so it might ask you for permissions to change your computer settings or firewall confirmation which you will have to accept and then within few seconds the installer will be configured.

Step 6


  • License agreement will be displayed. Go through it very carefully and accept the license terms.

Step 7


  • Windows provide you various options for setting up different types of MySQL installations. As of now, I have chosen Developer default since I am a developer & I require all the products that would aid my development purpose. Then, click Next.

Step 8


  • Depending upon your Windows configuration, it may ask you like “One or more product requirements have not been satisfied”. You can just click on YES.

Step 9


  • Click on Execute

Step 10


  • Once you click on Execute for executing the prior steps, then the installer grasps all recommended products in place and it asks for our approval to execute the product installation process. So again click on Execute.

Step 11


  • Once the execution process is successful, MySQL enables us to configure the server settings. Click on Next to configure the server

Step 12


  • In this step you can configure the server in two different modes i.e. Standalone mode or Cluster mode. Now, I am installing MySQL for development purpose hence I am selecting Standalone MySQL serverand clicking on  However, you can select the mode as per your requirement.

Step 14


  • From Config Type drop-down, choose the Development Computer option. You will see controls like TCP/IP, Port and X Protocol Port. If you want to configure your port, you can change here itself and click on Next. But for now, I am keeping it as default configuration.

Step 15


  • It will remind you to select the authentication method so let it be as the default recommended method and click on Next.

Step 16


  • In this step, set your MySQL root user password. If you want to create a new user then click on Add User button under MySQL user accounts section.

Step 17


  • Upon clicking on Add User button, you will get the user details popup which allows you to create a new user account. After creating the user click on Next.

Step 18


  • Let the service details be as default and click on Next.

Step 19


  • Click on Executeto apply for the configurations of the previous step.

Step 20


  • Upon execution, it will display green coloured ticks on every configuration option and eventually you will get Finish
  • Click on Finishbutton to get your MySQL on your Windows 10 operating system.

Conclusion


So, now follow the above mentioned steps to quickly Install MySQL in windows 10. Hope, this article was useful!

All the best!!


Introduction to MySQL:

  • Do you know how My SQL name was formed? Well, if you look at it carefully it is a combination of two names i.e. “My” it is the name of the co-founder Michael Widenius’s daughter and “SQL” is the full form of Structured Query Language. MySQL is one of the most popular open-source database management systems. It is easy to use, reliable, and fast. MySQL is a database management system that works on embedded systems as well as client-server systems.
  • Have you thought what makes MySQL so popular? MySQL is an open-source. It is used at a large scale hence a lot of code is readily available. Entire developed systems are also available which can be referred for the future projects. MySQL has relational databases therefore methodical storage is possible. It is also quick and robust.

What is the MySQL Installer?


  • MySQL installer can be easily installed if it is supported by the Wizard.
  • A simple to use wizard is provided by MySQL which aids the users to install MySQL with the elements like MySQL Server, All Available Connectors, MySQL Workbench, MySQL Notifier, Tools for excel and Microsoft visual Studio, MySQL Sample Databases.

Source

Today, in this article we have explained in detail how to install MySQL in windows 10. Here are the various steps required for installing MySQL on Windows 10.


Step 1


  • The first step is to download the latest MySQL community server from the official website of MySQL. The version at my end is 8.0.12, but even if the version is different for you still the installation process will be same.
  • By visiting the above mentioned website, you will see the options. Then, you have to select the OS as Microsoft windows and click on Go to Download page.
  • This will take you to the actual download page for windows MySQL server.

Step 2


  • Generally Available Releases will be displayed, and then you would be able to see two different installers i.e. Web community installer & MySQL installer community. Select MySQL installer community.

Step 3


  • Then MySQL credentials will be asked to download the .msi file. If your credentials are available then you can simply log in or if you want to sign up then go to green colored signup button and click it.
  • You also have the option to skip this step of login & signup by directly clicking on No thanks, just start my download option. And the downloading will begin on your local machine.

Step 4


  • Visit the download folder where mysql-installer-community file is visible and then right click on that file and select install option.

Step 5


  • The windows will begin the configuration process and while doing so it might ask you for permissions to change your computer settings or firewall confirmation which you will have to accept and then within few seconds the installer will be configured.

Step 6


  • License agreement will be displayed. Go through it very carefully and accept the license terms.

Step 7


  • Windows provide you various options for setting up different types of MySQL installations. As of now, I have chosen Developer default since I am a developer & I require all the products that would aid my development purpose. Then, click Next.

Step 8


  • Depending upon your Windows configuration, it may ask you like “One or more product requirements have not been satisfied”. You can just click on YES.

Step 9


  • Click on Execute

Step 10


  • Once you click on Execute for executing the prior steps, then the installer grasps all recommended products in place and it asks for our approval to execute the product installation process. So again click on Execute.

Step 11


  • Once the execution process is successful, MySQL enables us to configure the server settings. Click on Next to configure the server

Step 12


  • In this step you can configure the server in two different modes i.e. Standalone mode or Cluster mode. Now, I am installing MySQL for development purpose hence I am selecting Standalone MySQL serverand clicking on  However, you can select the mode as per your requirement.

Step 14


  • From Config Type drop-down, choose the Development Computer option. You will see controls like TCP/IP, Port and X Protocol Port. If you want to configure your port, you can change here itself and click on Next. But for now, I am keeping it as default configuration.

Step 15


  • It will remind you to select the authentication method so let it be as the default recommended method and click on Next.

Step 16


  • In this step, set your MySQL root user password. If you want to create a new user then click on Add User button under MySQL user accounts section.

Step 17


  • Upon clicking on Add User button, you will get the user details popup which allows you to create a new user account. After creating the user click on Next.

Step 18


  • Let the service details be as default and click on Next.

Step 19


  • Click on Executeto apply for the configurations of the previous step.

Step 20


  • Upon execution, it will display green coloured ticks on every configuration option and eventually you will get Finish
  • Click on Finishbutton to get your MySQL on your Windows 10 operating system.

Conclusion


So, now follow the above mentioned steps to quickly Install MySQL in windows 10. Hope, this article was useful!

All the best!!



0

Your Cart