MySQL Workbench

 

Complete Guide: Reinstall MySQL Workbench + MySQL Server (Windows)

This will completely reinstall everything properly so your connection works.

---

PART 1 — Remove Old Installation

Step 1: Uninstall MySQL

Press:

Windows + R

Type:

appwiz.cpl

Press Enter.

---

Step 2: Remove All MySQL Programs

Uninstall anything named:

• MySQL Workbench

• MySQL Server

• MySQL Installer

• MySQL Shell

• Connector

Remove all MySQL items.

Restart your PC after uninstalling.

---

PART 2 — Download MySQL

Step 3: Download Installer

Open:

MySQL Community Installer

Download:

mysql-installer-web-community

or full installer.

---

PART 3 — Install MySQL Correctly

Step 4: Open Installer

Double-click the installer.

Click:

• Yes (if Windows asks permission)

---

Step 5: Choose Setup Type

Select:

Developer Default

This installs:

• MySQL Server

• MySQL Workbench

• Shell

• Drivers

Click:

• Next

---

Step 6: Install Required Packages

If prompted:

• Click Execute

Wait for installation.

Then:

• Next

---

PART 4 — Configure MySQL Server

Step 7: Configuration Type

Leave defaults:

Option	Value
Config Type	Development Computer
Protocol	TCP/IP
Port	3306

Click:

• Next

---

Step 8: Authentication Method

Choose:

Use Strong Password Encryption

Click:

• Next

---

Step 9: Create Root Password

Create password.

Example:

Admin123

Write it down somewhere safe.

Click:

• Next

---

Step 10: Windows Service

Leave defaults:

Option	Value
Service Name	MySQL80
Start at Startup	Checked

Click:

• Next

---

Step 11: Apply Configuration

Click:

• Execute

Wait for all green checkmarks ✅

Then:

• Finish

---

PART 5 — Open MySQL Workbench

Step 12: Launch Workbench

Press Windows key.

Search:

MySQL Workbench

Open it.

---

PART 6 — Create Connection

Step 13: Create New Connection

On the home screen:

• Click the ➕ plus icon

Fill in:

Field	Value
Connection Name	Local MySQL
Hostname	127.0.0.1
Port	3306
Username	root

---

Step 14: Add Password

Click:

• Store in Vault

Enter your password:

• Example: Admin123

Click:

• OK

---

Step 15: Test Connection

Click:

• Test Connection

You should see:

Successfully made the MySQL connection

Click:

• OK

---

PART 7 — Start Writing SQL

Double-click your connection.

Click the SQL tab.

Paste:

CREATE DATABASE school;

USE school;

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

INSERT INTO students VALUES (1, 'John');

SELECT * FROM students;

Run using:

• ⚡ lightning icon

---

If It Still Does Not Work

Check service:

Press:

Windows + R

Type:

services.msc

Find:

• MySQL80

Status should be:

• Running

If not:

• Right-click → Start

---

Official MySQL Resources

MySQL Workbench Documentation

MySQL Server Documentation