How to install MySql on Windows
First step is to download the right package for installation of MySql on windows machine. You can download 32 bit or 64 bit version on download page based on you system configuration. We will download MySQL Community Server 5.7.9 for mysql website for installation. Other MySql products you can download are given below:
- MySQL Connectors.
- MySQL for Excel.
- MySQL Notifier.
- MySQL for Visual Studio.
Go to MySql website.
Click on download tab and then on windows tab as given below in snapshot.
Click on MySQL Installer link and scroll down on next page.
Here click on second installer “Windows (x86, 32-bit), MSI Installer” to download MySql installer.
You will get MSI File from mysql website as installable.
Now double click this MSI file and click on run.
In next step accept the agreement and click next.
Select custom installation.
Select the item that need to be installed. In this case we are installing My Sql server and connectors.
Click on next and you will see that items you have selected in previous step.
In this step set the port number and protocol for MySql server for install Mysql.
Provide the password for database in this step.
Select run MySQL server as service and at windows startup.
Click on execute on next step.
Final step and you are Done.
Now open the MySql cmd from programs.
Provide MySql password which was set in step 12.
Now we will test our MySql installation by firing some SQL Commands. Initially we need to select some database which is already present inside MySql database. As this is new installation we don’t know about already present database, so we will create one database.
CREATE DATABASE PROJECTS
Now we have to select that database which we want to use. So we will select our newly created database to continue.
As we have selected our database we can now create table in that database. We will use below query for that.
CREATE TABLE project( id INT(6) UNSIGNED PRIMARY KEY, projectname VARCHAR(30) NOT NULL );
You have successfully installed the MySql server on your windows machine.