Scribd
Upload
5 views2 pages

MySQL Workbench Installation Guide

This guide provides step-by-step instructions for installing MySQL Server and MySQL Workbench, including system requirements and common troubleshooting tips. It covers downloading the installer, configuring the server, setting a root password, and testing the installation. Additionally, it offers solutions for common errors and instructor tips for effective lab preparation.

Uploaded by

iqrakalro5678
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

MySQL Workbench Installation Guide

This guide provides step-by-step instructions for installing MySQL Server and MySQL Workbench, including system requirements and common troubleshooting tips. It covers downloading the installer, configuring the server, setting a root password, and testing the installation. Additionally, it offers solutions for common errors and instructor tips for effective lab preparation.

Uploaded by

iqrakalro5678
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Complete Guide: Installing MySQL Workbench

Overview
This guide helps students install MySQL Server and MySQL Workbench for database labs. MySQL Server is
the database engine, while Workbench is the graphical interface used to interact with it.

System Requirements
• Windows 10/11 recommended
• Minimum 4 GB RAM (8 GB preferred)
• 2–3 GB free disk space

Step 1: Download MySQL Installer


Visit: [Link]
Download mysql-installer-community (full version recommended).

Step 2: Run Installer


Launch the installer and select setup type:
✔ Developer Default (recommended for students and labs).

Step 3: Install Components


The installer will download and install:
• MySQL Server
• MySQL Workbench
• Shell and connectors
Click Execute and wait until installation completes.

Step 4: Configure MySQL Server


Choose configuration type: Standalone MySQL Server.
Server Type: Development Machine.
Default port: 3306 (change only if conflict occurs).

Step 5: Set Root Password


Create a root password (example: root123). Write it down carefully. Optionally create another user account
for lab use.

Step 6: Start MySQL Service


Ensure MySQL is installed as a Windows service (MySQL80) and running successfully.

Step 7: Launch MySQL Workbench


Open Start Menu → MySQL → MySQL Workbench.
Click Local Instance MySQL80 and enter your root password to connect.

Test Installation
Run the query:
SELECT VERSION();
If a version number appears, installation is successful.

Common Errors and Fixes


Port 3306 Already in Use
Cause: XAMPP or previous MySQL installation.
Fix: Change port to 3307 or stop other MySQL services.
MySQL Service Not Starting
Run installer as Administrator or temporarily disable antivirus.

Forgot Root Password


Reset password using MySQL reset method or reinstall (simplest for students).

Instructor Tips
• Ask students to install before lab day.
• Use a standard password policy for labs.
• Demonstrate difference between MySQL Server and Workbench.
• Verify service is running using [Link].

End of Guide

You might also like