a) Installing Mysql on Windows

1.Download Mysql zip(mysql-5.6.38-winx64) file

2. Extract the mysql folder

3. Execute the following commands
Step1: Run the server using the below command(C:\Softwares\mysql-5.6.38-winx64\bin)
Run mysqld --console

Step2: Reset the below command in new command prompt:(C:\Softwares\mysql-5.6.38-winx64\bin)

mysqladmin -u root password mysql

Step3: Connect mysql using the follwing command in new command prompt:(C:\Softwares\mysql-5.6.38-winx64\bin)

mysql -u root -p mysql

Step 4: Create database

create database db;

Step 5: Using the newly created db:

use db;


Step 6 : Shutdown of the Mysql
Run the server using the below command(C:\Softwares\mysql-5.6.38-winx64\bin)

Run mysqladmin -u root shutdown




b) Executing the mysql through mysql workbench:

1.Download Workbench from the below link:

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

2. Extract the file
3. Run the mysql work bench