Set up MySQL database on Windows

Prerequisite

Before downloading MySQL database, we need to make sure that our machine has Microsoft .NET framework version 4.5.2 or higher

To check the same open powershell by following navigation

Windows -> PowerShell

Run the following command to check the version of .NET framework

Get-ChildItem 'HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP' -Recurse | Get-ItemProperty -Name version -EA 0 | Where { $_.PSChildName -Match '^(?!S)\p{L}'} | Select PSChildName, version

In the above snapshot we can see that it is already installed with version 4.8. In case, it is not installed, then follow the below steps.

Install .NET framework

Note -> Please note that this step is required only if .NET framework is not installed on your machine. (We have verified this in the previous step)

To install .NET framework, click here or, go to website – https://dotnet.microsoft.com/en-us/download/dotnet-framework/net48

Download MySQL

After .NET framework is installed successfully, we can proceed with MySQL database installation

Step 1 : Visit the following website to download the installer for MySQL

https://dev.mysql.com/downloads/installer/

choose the below option

Step 2 : This will install installer file on windows as shown below

Now, start installing the database by double cliking on this installer file

Step 3 : Click Next

Step 4 : Click Next

Step 5 : Click Next

Step 6 : Click Execute

Step 7 : Upon successful completion, following screen will appear. Click Next

Step 8 :

Step 9 : Leave all the settings as it is and click Next

Step 10 :

Step 11 : Enter a password for ‘Root’ user and note it down somewhere. It will be used later

Step 12 : Add user by clicking on the Add User button on right hand side

Step 13 :

Step 14 :

Step 15 :

Step 16 :

Step 17 :

Step 18 :

Step 19 :

Step 20 : Test the connection after entering password for the user ‘root’ created in step 11. and clicking on the ‘Check’ button.

Step 21 : Upon successful completion, you will get following screen

Step 22 :

Step 23 :

Step 24 :

Step 25 :

Click Finish button and installation is complete.

Step 26 : Set environment variable called MYSQL_HOME

Step 27 : Edit path variable and make this entry of MySQL database

Test the MySQL database

Open command prompt and run below command

mysql -u root -p

Enter password for user ‘root’ created in step 11. Upon successful login, following screen will appear

This completes installation and testing of MySQL database on windows