Installing MySQL Server0%

Installing MySQL Server

Beginner12 min read•Updated: 2026-09-12

Installing MySQL Server on Windows, macOS, and Linux

Before you can run SQL commands, you need a functioning MySQL Server installed and running on your local development machine or server. This tutorial walks you through installing MySQL Server on Windows, macOS, and Linux (Ubuntu/Debian).

1. Installing MySQL on Windows

On Windows, the easiest and most robust method is using the official MySQL Community Installer.

1Step 1: Download the installer from https://dev.mysql.com/downloads/installer/
2        Choose the "mysql-installer-community-*.msi" package.
3 
4Step 2: Choose Setup Type
5        - For beginners, select "Developer Default" or "Custom".
6        - Ensure "MySQL Server" and "MySQL Workbench" are checked.
7 
8Step 3: Authentication Method
9        - Select "Use Strong Password Encryption (Recommended)".
10        - Set a strong password for the 'root' superuser account.
11        - CRITICAL: Remember or securely record this root password!
12 
13Step 4: Windows Service Configuration
14        - Keep "Start the MySQL Server at System Startup" enabled.
15        - Standard Windows service name: MySQL80 or MySQL84.
16 
17Step 5: Complete Installation and Verify
18        - Open Windows PowerShell or Command Prompt.
19        - Run: mysql -u root -p
20        - Enter your password to enter the MySQL prompt!

2. Installing MySQL on Linux (Ubuntu / Debian)

On Linux servers, MySQL is installed via the standard package management system (apt).

1# 1. Update your local package index
2sudo apt update
3 
4# 2. Install the MySQL Server package
5sudo apt install mysql-server -y
6 
7# 3. Check the status of the background mysqld service
8sudo systemctl status mysql
9 
10# 4. Run the security configuration script
11sudo mysql_secure_installation
12# This wizard prompts you to:
13# - Validate password strength
14# - Set root password
15# - Remove anonymous test users
16# - Disallow remote root login
17# - Remove the test database
18# - Reload privilege tables

3. Installing MySQL on macOS

On macOS, developers typically install MySQL using Homebrew:

1# 1. Update Homebrew formulas
2brew update
3 
4# 2. Install MySQL
5brew install mysql
6 
7# 3. Start the MySQL service as a background process
8brew services start mysql
9 
10# 4. Run the security hardening script
11mysql_secure_installation

4. Environment Variables & PATH Configuration

If typing mysql in your terminal returns 'mysql' is not recognized as an internal or external command, MySQL's bin directory is not in your system's PATH.

Adding MySQL to PATH on Windows:

1
Locate the MySQL bin folder (typically C:\Program Files\MySQL\MySQL Server 8.0\bin).
2
Search for "Edit the system environment variables" in the Windows Start menu.
3
Click Environment Variables -> Select Path under System variables -> Click Edit.
4
Click New and paste the path: C:\Program Files\MySQL\MySQL Server 8.0\bin.
5
Click OK on all dialogs and restart your terminal!

5. Best Practices & Common Pitfalls

Never Lose the Root Password: Recovering a lost root password requires stopping mysqld and starting it with --skip-grant-tables. Always save your credentials safely.
Port Conflict (Error 3306 in use): If you already have XAMPP, WAMP, or Docker running a MariaDB/MySQL container, port 3306 may be blocked. Stop the competing service or change MySQL's port in my.ini / my.cnf.
Do Not Use Root for Everyday Apps: Create dedicated application users with restricted permissions instead of using root for development projects.

Interactive Quiz• Knowledge Check

Multiple Choice Questions

Question 1

What utility script is used on Linux and macOS to secure a fresh MySQL installation?

Question 2

If Windows Command Prompt states "'mysql' is not recognized as an internal or external command", what is the cause?

Question 3

Which package manager is commonly used to install MySQL on macOS?

Question 4

Which command checks the live execution status of the MySQL background daemon on Ubuntu Linux?

Question 5

Why should production applications NOT connect to MySQL using the 'root' superuser?

Next Lesson

MySQL Command-Line Client (CLI)

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
MySQL Architecture & Client-Server Model	MySQL Command-Line Client (CLI)

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next

PreviousPrevNext

MSK Institute • Shikohabad

Loading Page Content...

Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...

Connecting serverPlease wait...

💻 Practical Labs🚀 Free Demo📜 Verified Certificates

MySQL Command-Line Client (CLI)

Installing MySQL Server

Beginner12 min read•Updated: 2026-09-12

Study Materials Cheatsheet

Installing MySQL Server on Windows, macOS, and Linux

1. Installing MySQL on Windows

On Windows, the easiest and most robust method is using the official MySQL Community Installer.

1Step 1: Download the installer from https://dev.mysql.com/downloads/installer/
2        Choose the "mysql-installer-community-*.msi" package.
3 
4Step 2: Choose Setup Type
5        - For beginners, select "Developer Default" or "Custom".
6        - Ensure "MySQL Server" and "MySQL Workbench" are checked.
7 
8Step 3: Authentication Method
9        - Select "Use Strong Password Encryption (Recommended)".
10        - Set a strong password for the 'root' superuser account.
11        - CRITICAL: Remember or securely record this root password!
12 
13Step 4: Windows Service Configuration
14        - Keep "Start the MySQL Server at System Startup" enabled.
15        - Standard Windows service name: MySQL80 or MySQL84.
16 
17Step 5: Complete Installation and Verify
18        - Open Windows PowerShell or Command Prompt.
19        - Run: mysql -u root -p
20        - Enter your password to enter the MySQL prompt!

2. Installing MySQL on Linux (Ubuntu / Debian)

On Linux servers, MySQL is installed via the standard package management system (apt).

1# 1. Update your local package index
2sudo apt update
3 
4# 2. Install the MySQL Server package
5sudo apt install mysql-server -y
6 
7# 3. Check the status of the background mysqld service
8sudo systemctl status mysql
9 
10# 4. Run the security configuration script
11sudo mysql_secure_installation
12# This wizard prompts you to:
13# - Validate password strength
14# - Set root password
15# - Remove anonymous test users
16# - Disallow remote root login
17# - Remove the test database
18# - Reload privilege tables

3. Installing MySQL on macOS

On macOS, developers typically install MySQL using Homebrew:

1# 1. Update Homebrew formulas
2brew update
3 
4# 2. Install MySQL
5brew install mysql
6 
7# 3. Start the MySQL service as a background process
8brew services start mysql
9 
10# 4. Run the security hardening script
11mysql_secure_installation

4. Environment Variables & PATH Configuration

If typing mysql in your terminal returns 'mysql' is not recognized as an internal or external command, MySQL's bin directory is not in your system's PATH.

Adding MySQL to PATH on Windows:

1
Locate the MySQL bin folder (typically C:\Program Files\MySQL\MySQL Server 8.0\bin).
2
Search for "Edit the system environment variables" in the Windows Start menu.
3
Click Environment Variables -> Select Path under System variables -> Click Edit.
4
Click New and paste the path: C:\Program Files\MySQL\MySQL Server 8.0\bin.
5
Click OK on all dialogs and restart your terminal!

5. Best Practices & Common Pitfalls

Never Lose the Root Password: Recovering a lost root password requires stopping mysqld and starting it with --skip-grant-tables. Always save your credentials safely.
Port Conflict (Error 3306 in use): If you already have XAMPP, WAMP, or Docker running a MariaDB/MySQL container, port 3306 may be blocked. Stop the competing service or change MySQL's port in my.ini / my.cnf.
Do Not Use Root for Everyday Apps: Create dedicated application users with restricted permissions instead of using root for development projects.

Interactive Quiz• Knowledge Check

Multiple Choice Questions

Question 1

What utility script is used on Linux and macOS to secure a fresh MySQL installation?

Question 2

If Windows Command Prompt states "'mysql' is not recognized as an internal or external command", what is the cause?

Question 3

Which package manager is commonly used to install MySQL on macOS?

Question 4

Which command checks the live execution status of the MySQL background daemon on Ubuntu Linux?

Question 5

Why should production applications NOT connect to MySQL using the 'root' superuser?

Next Lesson

MySQL Command-Line Client (CLI)

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
MySQL Architecture & Client-Server Model	MySQL Command-Line Client (CLI)

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next