Install MySQL

Before learning SQL, you need a Database Management System (DBMS) to execute SQL queries.

One of the most popular databases is:

MySQL is:

Used by companies such as:

What is MySQL?

MySQL is a Relational Database Management System (RDBMS) used to store, manage, and retrieve data using SQL.

Why Learn MySQL?

Benefits:

System Requirements

Minimum Requirements:

Recommended:

Installing MySQL on Windows

Step 1: Download MySQL Installer

Visit:

Download:

Step 2: Run Installer

Double-click:

Step 3: Choose Setup Type

Available options:

For beginners choose:

This installs:

Step 4: Install Required Components

Installer may ask to install:

Install all required dependencies.

Step 5: Configure MySQL Server

Choose:

Step 6: Select Configuration Type

Choose:

This uses fewer system resources.

Step 7: Configure Port

Default MySQL Port:

Keep default value.

Step 8: Set Authentication Method

Choose:

Recommended option.

Step 9: Create Root Password

Example:

Important:

You will need it every time you connect to MySQL.

Step 10: Configure Windows Service

Keep default settings:

Step 11: Apply Configuration

Click:

Wait for configuration to complete.

Step 12: Finish Installation

Click:

MySQL is now installed.

Verify MySQL Installation (Windows)

Open Command Prompt:

Expected Output:

Connect to MySQL

Open Command Prompt:

Enter password.

Successful connection:

Installing MySQL on Ubuntu Linux

Update Packages

Install MySQL

Start MySQL

Enable Auto Start

Check Status

Expected:

Secure MySQL Installation

Run:

This helps:

Connect to MySQL (Linux)

or

Installing MySQL on macOS

Step 1: Download MySQL

Visit:

Download:

Step 2: Run Installer

Open downloaded DMG file.

Step 3: Follow Installation Wizard

Click:

Step 4: Set Root Password

Create secure password.

Example:

Step 5: Complete Installation

Click:

Verify Installation (macOS)

Open Terminal:

MySQL Workbench

During installation you also get:

Workbench provides:

Connect Using MySQL Workbench

Open:

Create connection:

Click:

First MySQL Query

After connecting:

Output:

Show Existing Databases

Example Output:

Create Your First Database

Use Database

Verify Current Database

Output:

Common Installation Problems

MySQL Command Not Found

Problem:

Solution:

Add MySQL bin directory to system PATH.

Example:

Port 3306 Already In Use

Problem:

Solution:

Change port during installation:

Forgot Root Password

Solution:

Reset MySQL root password using recovery mode.

Service Not Running

Windows:

Start:

Linux:

Best Practices

Quick Commands Reference

Check Version:

Login:

Show Databases:

Create Database:

Use Database:

Summary

In this lesson, you learned:

• What MySQL is
• Why MySQL is popular
• Installing MySQL on Windows
• Installing MySQL on Linux
• Installing MySQL on macOS
• Verifying installation
• Using MySQL Workbench
• Running your first SQL query
• Common installation issues and solutions

You are now ready to start writing SQL queries in a real database environment.

Next Step

Continue to:

install-postgresql.mdx →