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.
Now we have to select the appropriate package for our operating system, in this case Windows .
And finally we will see the option to download the main installer .
It will offer us the option to register, we can skip the step and proceed to download the file directly.
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.
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.
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.
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.
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 ”.
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.
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.
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.
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"
A final window will appear to execute the necessary scripts to complete the process.
We have already finished configuring MySQL on Windows 10. The installer will give us the option to start the MySQL tools.
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.
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"
You will receive a successful connection message.
Click "OK" to add the user.
Now you can click on the user to establish the connection with the SQL server.
This will open the MySQL work tool so that you can start working with your databases.
This is all you need to do to use MySQL. If you liked the post you can share it to help more users.