How to install MySQL database on Windows 10

How to install MySQL database on Windows 10

Databases are an essential tool for many workers. One of the best database managers is MySQL, which is also totally free, and is available on Linux, Windows and Mac. Today we explain how you can install MySQL on Windows 10 .

What is and how does MySQL work

MySQL is one of the most advanced related database managers out there, with the added benefit of being free and cross-platform. This free software tool will allow you to manage databases both locally and remotely.

MySQL includes several programs, with MySQL Server and MySQL Workbench being the most important. The first one is the one that is really the database, while the second program offers the most advanced administration and query options for the databases.

Being multiplatform , it will serve you for all your projects, and you will not have to learn to manage a program for each of them. This is a very important saving of time and resources in the professional sector.

How to install MySQL in Windows 10 step by step

After this brief introduction to MySQL, we can now proceed with the download and installation of all the tools we need to work with this powerful cross-platform and Open Source database manager.

The first step is to go to the official website of the project. Once inside, click on the option " MySQL Community Server " on the main screen.

How to install MySQL database on Windows 10 1

Now we have to select the appropriate package for our operating system, in this case Windows .

How to install MySQL database on Windows 10 2

And finally we will see the option to download the main installer .

How to install MySQL database on Windows 10 3

It will offer us the option to register, we can skip the step and proceed to download the file directly.

How to install MySQL database on Windows 10 4

After that, the MySQL installer download process will begin. Once it's done, we just need to double click on the file to run it. The installer will check for an update to the installation package before continuing.

Once the verification is complete, you can proceed with the installation. The first step will be to accept the license agreement to be able to use MySQL.

How to install MySQL database on Windows 10 5

Then we will have to choose the type of installation we want to do. We recommend leaving the option marked by default, since it will allow us to install only the elements we need. This way we will avoid filling our hard drive with files that we do not need.

If you don't want to complicate things, you can use the "Full" option to do a complete installation.

How to install MySQL database on Windows 10 6

The next step is to verify that the requirements for using MySQL are met . The installation program offers you the possibility to install all the necessary elements. When it is finished you can continue with the installation.

How to install MySQL database on Windows 10 7

Now a window will appear with information on all the programs that will be installed. Click on " Execute " to proceed with its installation. After that, the download and installation of all the necessary components will begin so that you can use the MySQL databases.

How to install MySQL database on Windows 10 8

How to install MySQL database on Windows 10 9

When the first part of the MySQL installation is complete, the next step is to configure the program correctly.

How to configure MySQL in Windows 10

We begin with the MySQL configuration process in Windows 10 , a fundamental step to be able to use this advanced tool for creating and managing databases.

To start with the MySQL configuration we click on “Next” and after that we choose the first option available “ Standalone MySQL Server / Classic MySQL Replication ”.

How to install MySQL database on Windows 10 10

How to install MySQL database in Windows 10 11

After that, a new screen will appear in which we will have to configure some important parameters of the equipment, in addition to protocols and TCP ports that will be used to establish remote connections with the SQL server. By default, port 3306 will be marked, we can leave it like this, and it will be the port that we have to open from the router to be able to make the connection with the SQL server.

How to install MySQL database on Windows 10 12

The next step is to configure the preferences for starting the daemon and the use of user accounts. We leave you a gallery of images for illustrative purposes.

After clicking on “ Execute ” in the last window, all the actions and the activation of the corresponding services will be carried out in the Windows operating system. If all goes well, we will see a confirmation message appear at the end of the process. We click on "Finish" and everything will be completed.

How to install MySQL database on Windows 10 17

The next step will be to configure the router , for this we click on " Next " in the window that will appear. We can leave everything as it comes by default, as it will not be necessary to touch anything.

How to install MySQL database on Windows 10 18How to install MySQL database on Windows 10 19

Finally, you have to connect to the server using the root user and the password that we have previously defined. We enter them and click on "Check", if everything is fine we can click on "Next"

How to install MySQL database on Windows 10 20How to install MySQL database in Windows 10 21

A final window will appear to execute the necessary scripts to complete the process.

How to install MySQL database on Windows 10 22

We have already finished configuring MySQL on Windows 10. The installer will give us the option to start the MySQL tools.

How to install MySQL database on Windows 10 23

How to connect to MySQL server from MySQL Workbench application

If you have decided to install the graphical MySQL Workbench client during the MySQL installation process, you will have to do a last step which consists of connecting the application to a server in order to use it. Click on the icon that we mark in the image to add a user.

connect to MySQL server from MySQL Workbench 01 application

Now you will have to give your username a name . The rest of the options can be left as they are if you have followed this tutorial step by step. Click on "Test Connection"

connect to MySQL server from MySQL Workbench 02 application

You will receive a successful connection message.

connect to MySQL server from MySQL Workbench 03 application

Click "OK" to add the user.connect to MySQL server from MySQL Workbench 04 application

Now you can click on the user to establish the connection with the SQL server.connect to MySQL server from MySQL Workbench 05 application

This will open the MySQL work tool so that you can start working with your databases.

connect to MySQL server from MySQL Workbench 06 application

This is all you need to do to use MySQL. If you liked the post you can share it to help more users.