Installing the MySQL Database on Window
First you need to Download MySQL Server from MySQL Community Server and follow the below steps to install MySQL on Window plateform.
MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.
Installing MySQL on Windows
Go to MySQL official website https://dev.mysql.com/downloads/mysql/
Select the right version for MySQL community server which you want.
Download Zip Archive from list.
Click on downloaded EXE file to begin MySQL installation.
Select MySQL Server from available products and click on Next button.
Configure the path where you want to install MySQL Server. The default path will be under Program Files.
Now click on Execute button to start installation.
Now set default password for MySQL Server and click on Next botton.
Now click on Finish botton.
Congratulation, you have installed MySQL Server on your Windows environment successfully. The default installer setup.exe will walk you through the trivial process and by default will install everything under C:\mysql.
Verify MySQL installation
Now verify MySQL installation. Go to start button on window and find MySQL command line client and click.
Once you open MySQL Command Line Client, it will appeared with a mysql> prompt. If you have set any password, type your password and press enter here. Now, you are connected to the MySQL server and you can execute all the SQL command at mysql> prompt as follows:
New check existing databases with show databases command: