How to Install MySQL

MySQL Installation-tutorial

Video Tutorial Discussion

Step 1: Download MySQL

Go to the official MySQL download page Download MySQL

Click on “MySQL Installer for Windows”

Step 2: Installing MySQL on Windows

1. Run the Installer

Double-click the downloaded file:

mysql-installer-community-*.msi

Choose “Developer Default” setup type.

This will install:

MySQL Server

MySQL Workbench

MySQL Shell

Connectors (optional)

2. Configure MySQL Server

When the setup reaches the configuration screen:

Choose Development Machine

Keep the default port: 3306

Set a Root Password (important! Write it down)

Optionally, create a new user account

Select Run as Windows Service so MySQL starts automatically

3. Complete the Installation

Click Execute → wait for all items to install → click Finish.

4. Verify the Installation

Open Command Prompt (CMD) and type:

mysql --version

You should see something like

mysql  Ver 8.0.36 for Win64 on x86_64 (MySQL Community Server)

To log in to MySQL

mysql -u root -p

Enter your password --> you will see the MySQL prompt

mysql>

5. Test with MySQL Workbench

Open MySQL Workbench

Click “+” to add a new connection

Hostname: localhost

Username: root

Password: (your password)

Click Test Connection

If successful → You are ready to go!

Step 5: Test Your Setup with a Small Example

Let us quickly check if everything is working!

Run the following in MySQL CLI or Workbench:

CREATE DATABASE quipoin_demo;
USE quipoin_demo;

CREATE TABLE Books (
  BookID INT AUTO_INCREMENT PRIMARY KEY,
  Title VARCHAR(200),
  Author VARCHAR(100),
  Price INT
);

INSERT INTO Books (Title, Author, Price)
VALUES 
('Atomic Habits', 'James Clear', 550),
('Deep Work', 'Cal Newport', 499);

SELECT * FROM Books;

Output

BookID	Title	Author	Price
1	Atomic Habits	James Clear	550
2	Deep Work	Cal Newport	499

Congrats You have successfully installed MySQL and created your first table!