How To Install A MySQL Database In Windows 10

Tags:
sparkinwords
By See all their Tutorials
MySQL is one of the most popular open-source databases and is used by some of the biggest online brands. Installing it on Windows 10 isn’t hard. You just need to follow the method carefully to achieve great results.

For installing MySQL, you first need to visit their site and download the correct version of the system that suits your PC. Go to https://dev.mysql.com/downloads/installer/. Here you can download the latest version of MySQL and the one suited to your system’s configuration.

Once you have downloaded the database, comes the challenge of installing it on your PC and that is no big deal. Below are the few steps required to accomplish this.

Installing MySQL in Windows 10

1. Hit the installer icon that you will find in the downloaded .zip file and the process of installation begins.



2. Now the process of installation begins and you have to make careful choices at every step

3. When the MySQL installer box appears, you first need to formally accept the ‘License Agreement’ by clicking ‘Next’



4. Now the user will have to choose the kind of setup you want. If you go for the ‘Custom’ option, then you can manually choose the components to be installed.



5. All that remains to be done now is for you to press ‘Execute’ key and the installation process will be started and one by one, all the products that are part of the package you have selected will be installed.



6. Having installed MySQL, you now must configure it. The process starts as soon as the installation is complete. When you click the ‘Next’ button, the interface changes and new steps appear in the box. First among them is ‘Type and Networking’

7. Here you will have to make the selections according to the uses you are going to put this database through and the way you will be connected to MySQL server



8. The next stage is about setting your MySQL root password. Choose whichever one suits you and then click ‘Add User’. This will open another box where you can choose a username



9. The next stage in configuration is ‘Windows Service’ where you can set the program as a Windows service and see your ‘Windows Service Name’ apart from choosing whether MySQL server will be launched at startup or not



10. Next step is equally simple – press the ‘Execute’ key and the configuration would be complete and then press the ‘Finish’ button to conclude the process
Now that MySQL is properly installed, all you need to do is check whether its working properly. That again, is not a challenging task. Just look through the apps installed in your system and you will find a section of MySQL in which there would be ‘MySQL Command Line Client’ application.

Click on it and it will open a command prompt-like window where you would have to enter your password.


Enter the password and you are good to go.