Installing MySQL Server & Workbench: A Complete Guide for Windows, Linux & macOS

Introduction

MySQL is one of the most popular open-source relational database management systems. This guide covers everything from system requirements and installation to configuration, verification, and your first login — all in one place. Whether you're on Windows, Linux, or macOS, you'll have MySQL Server up and running by the end.

Table of Contents

1. System Requirements
2. Install MySQL Server
   • Install on Windows
   • Install on Linux
   • Install on macOS
3. Install MySQL Workbench
   • Install on Windows
   • Install on Linux
   • Install on macOS
   • Connect to a Server
4. MySQL Command Line Client
5. Configure MySQL Server
6. Verify Installation
7. Start and Stop MySQL Server
8. First Login
9. Best Practices

System Requirements

Hardware Requirements

Software Requirements

Prerequisites

• Administrator / root access on the machine
• Stable internet connection (for downloading the installer)
• A supported operating system (see table above)

Install MySQL Server

Install on Windows

Option 1 — MySQL Installer (Recommended)

The MySQL Installer is a single package that downloads and installs MySQL Server and related products.

Step 1: Download the Installer

1. Visit the official MySQL Downloads page
2. Choose either:
   • Web installer (small, downloads components during setup)
   • Full installer (larger, includes all components, works offline)

Note: The web installer requires internet during setup. The full installer is better if you're installing on multiple machines or have a slow connection.

Step 2: Run the Installer

1. Double-click the downloaded .msi file
2. Allow the app to make changes (UAC prompt)
3. Choose setup type:
   • Developer Default — installs MySQL Server, Workbench, and other tools
   • Server only — just the MySQL database server
   • Custom — pick specific components

Step 3: Configure MySQL Server

1. Select Standalone MySQL Server → Development Machine
2. Set Connectivity: TCP/IP, Port 3306 (default)
3. Set Authentication Method: Use Strong Password Encryption (recommended for MySQL 8+)
4. Set a strong root password — save it somewhere safe
5. Optional: Add additional user accounts
6. Configure Windows Service:
   • Check Configure MySQL Server as a Windows Service
   • Set service name (default: MySQL80)
   • Choose Start the MySQL Server at System Startup (recommended)

Step 4: Apply Configuration

1. Click Execute to apply settings
2. Wait for the installation and configuration to complete
3. Click Finish

Option 2 — ZIP Archive (Portable Install)

For advanced users who want full control:

# 1. Extract the ZIP to a folder (e.g., C:\mysql)
# 2. Create my.ini configuration file in the extracted folder
# 3. Initialize the data directory
mysqld --initialize --console
#    ^ Note the temporary root password from the output

# 4. Install as a Windows service
mysqld --install

# 5. Start the service
net start MySQL

Install on Linux

Ubuntu / Debian (APT)

# 1. Update package index
sudo apt update

# 2. Install MySQL Server
sudo apt install mysql-server -y

# 3. Check status
sudo systemctl status mysql

# 4. Run the security script
sudo mysql_secure_installation

Note: On some Ubuntu versions, the root user authenticates via auth_socket by default. To log in as root, use sudo mysql instead of mysql -u root -p.

The mysql_secure_installation script will prompt you to:

• Set a password for root
• Remove anonymous users
• Disallow root login remotely
• Remove test databases
• Reload privilege tables

RHEL / CentOS / Fedora (YUM/DNF)

# 1. Add the official MySQL repository
sudo dnf install https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm

# 2. Install MySQL Server
sudo dnf install mysql-server -y

# 3. Start the server
sudo systemctl start mysqld

# 4. Enable auto-start on boot
sudo systemctl enable mysqld

# 5. Get the temporary root password
sudo grep 'temporary password' /var/log/mysqld.log

# 6. Run the security script (use the temp password)
sudo mysql_secure_installation

Install on macOS

Option 1 — Homebrew (Recommended)

# 1. Update Homebrew
brew update

# 2. Install MySQL
brew install mysql

# 3. Start MySQL
brew services start mysql

# 4. Run the security script
mysql_secure_installation

Option 2 — Official DMG Installer

1. Download the .dmg file from dev.mysql.com/downloads/mysql/
2. Open the DMG and double-click the installer .pkg
3. Follow the installation wizard
4. Important: The installer displays a temporary root password at the end — copy it immediately
5. Configure MySQL to start automatically (optional): System Preferences → MySQL → Check Start MySQL when system starts

Install MySQL Workbench

MySQL Workbench is a graphical tool for database design, development, and administration. It provides three main functional areas:

Prerequisite: MySQL Server must be installed and running before Workbench can connect.

Install on Windows

Via MySQL Installer (Recommended)

If you already ran the MySQL Installer for the server:

1. Open the MySQL Installer from the Start Menu
2. Click Add next to installed products
3. Find MySQL Workbench in the product list
4. Check the box and click the green arrow to select it
5. Click Next → Execute → Finish

Standalone Install

1. Visit dev.mysql.com/downloads/workbench/
2. Download the .msi installer for Windows
3. Double-click the file and follow the wizard
4. Launch from the Start Menu

Install on Linux

# Ubuntu / Debian — via APT
sudo apt update
sudo apt install mysql-workbench -y

# Or use snap (recommended for newer versions)
sudo snap install mysql-workbench-community

# Fedora / RHEL
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-<version>-fedora.rpm
sudo dnf install ./mysql-workbench-community-*.rpm

Note: Oracle has discontinued standalone Linux packages for newer Workbench versions. The snap package is the recommended approach.

Install on macOS

# Using Homebrew
brew install --cask mysql-workbench

# Or download the .dmg from dev.mysql.com/downloads/workbench/
# and drag the app to the Applications folder

Connect to a Server

1. Launch MySQL Workbench
2. Click the + icon next to MySQL Connections
3. Fill in the details:

4. Click Test Connection
5. If successful, click OK

MySQL Command Line Client

The MySQL Command Line Client is a text-based interface that ships with every MySQL Server installation.

Launching the Client

Basic Syntax

mysql -u <username> -p [-h <hostname>] [-P <port>]

Examples

# Connect to local MySQL as root
mysql -u root -p

# Connect to a remote MySQL server
mysql -u admin -p -h 192.168.1.100 -P 3306

Useful Client Commands (inside mysql> prompt)

SHOW DATABASES;         -- List all databases
USE database_name;      -- Switch to a database
SHOW TABLES;            -- List tables in current database
SELECT VERSION();       -- Show MySQL version
STATUS;                 -- Show server status info
EXIT;                   -- Exit the client (or \q)

Configure MySQL Server

MySQL reads configuration from a file at startup. Modifying this file lets you change server behavior.

Configuration File Location

Common Configuration Options

[mysqld]
# Network
port = 3306
bind-address = 127.0.0.1

# Storage
datadir = /var/lib/mysql
max_allowed_packet = 64M

# Performance
innodb_buffer_pool_size = 1G
max_connections = 151

# Security
skip-external-locking
skip-name-resolve

Configuration Sections

Important: After editing the configuration file, you must restart the MySQL Server for changes to take effect.

Verify Installation

Run these checks to confirm MySQL is installed and working correctly.

Check 1 — Server Process Running

# Windows
tasklist | findstr mysql

# Linux / macOS
ps aux | grep mysql
# or
systemctl status mysql

Check 2 — Version

mysql --version

Expected output: mysql Ver 8.0.x for <os> on <arch>

Check 3 — Connectivity

mysql -u root -p -e "SELECT 'MySQL is working!' AS status;"

Expected output: A single row showing MySQL is working!

Check 4 — Database List

mysql -u root -p -e "SHOW DATABASES;"

Expected output:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

Note: These four databases are created by default. Do not delete or modify the mysql database unless you know what you're doing.

Start and Stop MySQL Server

Windows

# Via Command Prompt (Admin)
net start MySQL80          # Start
net stop MySQL80           # Stop

# Via Services GUI
# Win + R → services.msc → Find "MySQL80" → Start / Stop / Restart

Linux (systemd)

sudo systemctl start mysql      # Start
sudo systemctl stop mysql       # Stop
sudo systemctl restart mysql    # Restart
sudo systemctl status mysql     # Check status
sudo systemctl enable mysql     # Auto-start on boot
sudo systemctl disable mysql    # Disable auto-start

macOS

# With Homebrew
brew services start mysql
brew services stop mysql
brew services restart mysql

# With DMG installer: System Preferences → MySQL → Start/Stop

First Login

Step-by-step Walkthrough

1. Open a terminal (or Command Prompt on Windows)

2. Launch the MySQL client:

   mysql -u root -p
   

3. Enter the root password when prompted

4. You should see:

   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 8
   Server version: 8.0.x
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input.
   mysql>
   

5. Run your first command:

   mysql> SELECT "Hello, MySQL!" AS message;
   

   Output:

   +----------------+
   | message        |
   +----------------+
   | Hello, MySQL!  |
   +----------------+
   1 row in set (0.00 sec)
   

6. Exit the client:

   mysql> EXIT;
   

Changing the Root Password (if needed)

-- Run inside the mysql client
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourNewStrongPassword';
FLUSH PRIVILEGES;

Best Practices

• Use a strong root password — at least 12 characters with mixed case, numbers, and symbols
• Run mysql_secure_installation after every fresh installation
• Use the official MySQL repository on Linux — distribution packages may be outdated
• Use a non-root user for daily work — create a limited user with CREATE USER and GRANT
• Don't expose port 3306 to the internet — bind to 127.0.0.1 for local-only access
• Restart MySQL after config changes — edits to my.cnf / my.ini only apply on restart
• Keep MySQL updated — regularly run apt upgrade / brew upgrade / the MySQL Installer
• Back up configuration files before making edits
• Store passwords in the system keychain when using Workbench
• Check logs first if something breaks:
  • Linux: /var/log/mysql/error.log
  • Windows: C:\ProgramData\MySQL\MySQL Server 8.0\Data\*.err
  • macOS: check Homebrew logs with brew services --help