Here’s why you might want to install MySQL on Windows 10 and how to do so.
Why Install MySQL on Windows 10?
MySQL is free, open-source software, and you can even download the source code if you like. For many, this is one reason it was trusted to be part of the world’s most popular web platform. In more practical terms, it means you can freely download and use MySQL for yourself. Why would you want to do this? Well, if you’re curious about technology, you can play around with it to see how it works. You can create your own databases, either for educational purposes or keep track of important items at home. You could also install it to learn SQL, the programming language used to manage and interact with most databases.
How to Download MySQL’s Free Community Edition
Before installing the MySQL Free Community edition, download it on your PC:
How to Install MySQL on Windows 10
To install MySQL:
If you have an active Internet connection, select the top download.If you have to be offline when you install, select the bottom download.
How to Start and Stop the MySQL Server
The key to working with MySQL is a running server. You can start and stop the server from the Windows Services app. First, open the MySQL Servers and expand the MySQL Server folder and select the appropriate version for your system to move it to the right column.
Group Replication: Select Standalone MySQL Server / Classic MySQL Replication.Type and Networking: Select the default Config Type Development Computer, which will set things up for you to work locally.Authentication Method*: Select Use Strong Password Encryption for Authentication.Accounts and Roles: Enter a password for your MySQL root (i.e., admin) user. Normally, you can (and should) set up at least one normal user with a name and password as well, but since you’re just testing things out, the root account will be enough.Windows Service: You can keep the defaults here, but you should select Start the MySQL Server at System Startup to disable it. As a general rule, try not to leave services you don’t need running on your machine.
