MySQL is one of the most popular relational database management systems used for web applications, APIs, enterprise software, and data-driven applications.
Whether you’re working with Node.js, PHP, Python, Java, or another backend technology, knowing how to install and configure MySQL is an essential skill for many developers.
The installation process is different for Windows, macOS, and Linux, but the overall process is simple.
In this guide, you’ll learn how to install MySQL on all three operating systems, verify the installation, connect to the MySQL server, use MySQL Workbench, create your first database, and troubleshoot common installation problems.
What Is MySQL?
MySQL is an open-source relational database management system that uses SQL (Structured Query Language) to store, organize, and retrieve data.
Instead of storing application data in files, you can store structured information in tables.
For example:
users
--------------------------------
id | name | email
--------------------------------
1 | John | john@example.com
2 | Sarah | sarah@example.com
3 | Mike | mike@example.com
Applications can then use SQL queries to interact with this data.
For example:
SELECT *
FROM users;
MySQL is commonly used for:
- Web applications
- REST APIs
- E-commerce applications
- Content management systems
- Enterprise applications
- Data-driven websites
- Backend applications
MySQL Server vs MySQL Workbench
Before installing MySQL, it’s useful to understand the difference between MySQL Server and MySQL Workbench.
MySQL Server
MySQL Server is the actual database system.
It stores and manages your data and processes SQL queries.
Application
↓
MySQL Server
↓
Database
MySQL Workbench
MySQL Workbench is a graphical tool for working with MySQL.
It allows you to:
- Connect to MySQL
- Write SQL queries
- Create databases
- Create tables
- Manage users
- Design database schemas
- Inspect database objects
You can use MySQL without Workbench, but Workbench can make database administration easier for beginners.
MySQL Installation Requirements
Before installing MySQL, make sure you have:
- A Windows, macOS, or Linux computer
- Internet access
- Administrator or sudo privileges when required
- Enough disk space
- A terminal or command prompt
For production environments, you should use a supported MySQL release and follow your organization’s security and upgrade policies.
How to Install MySQL on Windows
The easiest way to install MySQL on Windows is to use the official MySQL Installer.
Step 1: Download MySQL Installer
Go to the official MySQL website and download the MySQL Installer for Windows.
Choose the appropriate current version for your system.
The installer can install MySQL Server along with additional tools such as MySQL Workbench.
Step 2: Start the MySQL Installer
After downloading the installer:
- Open the installer.
- Choose the installation type.
- Continue through the setup wizard.
For beginners, a setup that includes:
MySQL Server
MySQL Workbench
MySQL Shell
is generally convenient.
Step 3: Install MySQL Server
The installer will download and install the selected MySQL components.
Follow the installation wizard until you reach the server configuration section.
Step 4: Configure MySQL Server
During configuration, MySQL will ask you to select options such as:
Server configuration type
Networking
Authentication
Root password
Windows service
For a local development environment, the default configuration is usually suitable unless you have a specific requirement.
Step 5: Configure Authentication
MySQL provides modern authentication methods.
Use the recommended authentication method offered by your MySQL version unless your application or driver requires a specific compatibility option.
Step 6: Set the Root Password
The installer will ask you to create a password for the MySQL root account.
Choose a strong password.
For example:
MyStrongMySQLPassword
For production systems, use a long, unique password and store it securely.
Do not use simple passwords such as:
root
password
123456
mysql123
Step 7: Configure MySQL as a Windows Service
MySQL can run as a Windows service.
This allows MySQL to start automatically when Windows starts.
A typical service configuration looks like:
MySQL Server
↓
Windows Service
↓
Starts automatically
Keep the default service configuration unless you have a specific reason to change it.
Step 8: Complete the Installation
Continue through the wizard and allow the installer to configure the selected components.
Once the installation is complete, you can open MySQL Workbench or MySQL Shell.
Step 9: Verify MySQL on Windows
Open:
Command Prompt
or:
PowerShell
Run:
mysql --version
You should see something similar to:
mysql Ver 8.x.x
The exact version depends on the MySQL release you installed.
Connect to MySQL From Windows
Run:
mysql -u root -p
You’ll be prompted for your password.
Enter the root password you created during installation.
If the connection succeeds, you’ll see the MySQL prompt:
mysql>
You can now execute SQL queries.
Test MySQL
Run:
SELECT VERSION();
You should receive the installed MySQL version.
You can also run:
SHOW DATABASES;
This displays the databases available to your MySQL user.
How to Install MySQL on macOS
There are several ways to install MySQL on macOS.
Common approaches include:
1. MySQL Community Server installer
2. Homebrew
For developers, Homebrew is often convenient because it makes installation and updates easier.
Method 1: Install MySQL Using Homebrew
First, check whether Homebrew is installed:
brew --version
If Homebrew is installed, you can install MySQL with:
brew install mysql
Homebrew will download and install MySQL and its required files.
Step 2: Start MySQL
After installation, start the MySQL service:
brew services start mysql
This starts MySQL as a background service.
Step 3: Check MySQL Version
Run:
mysql --version
You should see the installed MySQL version.
Step 4: Connect to MySQL
Try:
mysql -u root
Depending on your MySQL installation and authentication configuration, you may or may not be prompted for a password.
If your root account requires a password, use:
mysql -u root -p
Step 5: Secure the Installation
MySQL provides a security configuration utility:
mysql_secure_installation
This can help you configure security-related options such as:
- Root account security
- Anonymous users
- Test databases
- Remote root access
Follow the prompts and choose settings appropriate for your environment.
Method 2: Install MySQL Using the Official Installer
You can also download the MySQL Community Server package for macOS from the official MySQL website.
Choose the package appropriate for your Mac’s architecture.
Modern Macs may use:
Apple Silicon
while older Macs may use:
Intel
After downloading the installer:
- Open the package.
- Follow the installation wizard.
- Configure the MySQL server.
- Set the root password.
- Complete the installation.
Then verify:
mysql --version
Check MySQL Service on macOS
If you’re using Homebrew:
brew services list
You should see MySQL listed as a running service.
To stop MySQL:
brew services stop mysql
To start it again:
brew services start mysql
How to Install MySQL on Linux
MySQL installation on Linux depends on your distribution.
Common Linux distributions include:
Ubuntu
Debian
Fedora
RHEL
Rocky Linux
AlmaLinux
The exact commands can differ.
For Ubuntu and Debian-based systems, the package manager is commonly apt.
Install MySQL on Ubuntu
First, update your package information:
sudo apt update
Then install MySQL:
sudo apt install mysql-server
Confirm the installation when prompted.
Step 2: Check MySQL Version
Run:
mysql --version
You should see the installed version.
Step 3: Check MySQL Service
Check the MySQL service:
sudo systemctl status mysql
If the service is running, you’ll see a status indicating that MySQL is active.
Step 4: Start MySQL
If MySQL isn’t running:
sudo systemctl start mysql
Step 5: Enable MySQL at Startup
To start MySQL automatically when the server boots:
sudo systemctl enable mysql
This is useful for development servers and production systems where the database should start automatically.
Step 6: Secure MySQL
Run:
sudo mysql_secure_installation
Follow the prompts to configure security-related options.
Depending on the MySQL version and initial configuration, the questions may include:
Password validation
Anonymous users
Remote root login
Test database
Privilege table reload
Choose settings appropriate for your environment.
Connect to MySQL on Ubuntu
Try:
sudo mysql
Depending on the authentication configuration, Ubuntu installations may configure the MySQL root account to authenticate through the operating system rather than using a traditional password.
You may also connect using:
mysql -u root -p
if a password-based root account has been configured.
Install MySQL on Other Linux Distributions
For distributions such as Fedora, RHEL, Rocky Linux, and AlmaLinux, installation steps can differ.
You may need to configure the appropriate MySQL repository before installing the server.
Always use installation instructions appropriate for your exact Linux distribution and supported MySQL version.
Verify MySQL Installation
Regardless of your operating system, the easiest verification is:
mysql --version
Then connect:
mysql -u root -p
After connecting:
SELECT VERSION();
If MySQL returns a version, the server is working.
Create Your First Database
Once MySQL is installed, you can create a database.
Run:
CREATE DATABASE myapp;
Check the databases:
SHOW DATABASES;
You should see:
myapp
Select a Database
Use:
USE myapp;
MySQL will respond with:
Database changed
You can now create tables inside this database.
Create Your First Table
Create a simple users table:
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL
);
Check the table:
SHOW TABLES;
You should see:
users
Insert Data
Add a user:
INSERT INTO users (name, email)
VALUES ('John Doe', 'john@example.com');
Add another:
INSERT INTO users (name, email)
VALUES ('Sarah Smith', 'sarah@example.com');
Read Data
Run:
SELECT *
FROM users;
You should see something like:
id | name | email
---|-------------|----------------------
1 | John Doe | john@example.com
2 | Sarah Smith | sarah@example.com
Your MySQL database is now working.
Create a Dedicated MySQL User
For applications, don’t use the root account.
Create a dedicated user:
CREATE USER 'app_user'@'localhost'
IDENTIFIED BY 'StrongPasswordHere';
Then grant only the required permissions.
For example:
GRANT ALL PRIVILEGES
ON myapp.*
TO 'app_user'@'localhost';
Then:
FLUSH PRIVILEGES;
The application can now connect using:
Username: app_user
Database: myapp
For production applications, use the minimum permissions required by the application rather than automatically granting broad privileges.
Connect to MySQL Using the New User
Run:
mysql -u app_user -p myapp
Enter the password when prompted.
If authentication succeeds, you’ll be connected to the myapp database.
MySQL Workbench
MySQL Workbench provides a graphical interface for MySQL.
After installing it, open MySQL Workbench and create a connection.
Typical local connection details are:
Hostname: localhost
Port: 3306
Username: root
or your dedicated application user.
The default MySQL port is:
3306
Enter your password and test the connection.
Create a MySQL Workbench Connection
In MySQL Workbench:
- Open MySQL Workbench.
- Select MySQL Connections.
- Create a new connection.
- Enter the connection name.
- Set hostname to
localhost. - Set port to
3306. - Enter your username.
- Test the connection.
- Save the connection.
You can then open the connection and execute SQL queries from the Workbench editor.
MySQL Shell
MySQL Shell is another command-line interface for working with MySQL.
It supports multiple modes and provides additional functionality beyond the traditional mysql client.
You may see commands such as:
mysqlsh
After opening MySQL Shell, you can connect to a server using the appropriate connection information.
For many beginners, the traditional mysql command is simpler for learning basic SQL.
MySQL Configuration
MySQL stores configuration in configuration files.
The exact file location depends on the operating system and installation method.
Configuration can control settings such as:
Port
Networking
Storage
Logging
Character sets
Connection limits
Performance settings
Don’t change production configuration blindly.
Test configuration changes before applying them to a production server.
Check Which Port MySQL Uses
The default MySQL port is:
3306
You can check your server configuration or use operating-system tools to determine which port MySQL is listening on.
For example, on Linux:
sudo ss -lntp | grep 3306
Start and Stop MySQL on Linux
Start:
sudo systemctl start mysql
Stop:
sudo systemctl stop mysql
Restart:
sudo systemctl restart mysql
Check status:
sudo systemctl status mysql
These commands are commonly used on systemd-based Linux systems.
Start and Stop MySQL on macOS With Homebrew
Start:
brew services start mysql
Stop:
brew services stop mysql
Restart:
brew services restart mysql
Check:
brew services list
Common MySQL Installation Problems
mysql: command not found
If you see:
mysql: command not found
your MySQL executable may not be available through your PATH.
Check where MySQL is installed and make sure the MySQL bin directory is available in your PATH.
On macOS or Linux, you can check:
which mysql
On Windows:
where.exe mysql
MySQL Service Is Not Running
If you cannot connect to MySQL, check whether the server is running.
On Linux:
sudo systemctl status mysql
On macOS with Homebrew:
brew services list
On Windows, check the Windows Services application for the MySQL service.
Access Denied for User
You might see:
ERROR 1045 (28000):
Access denied for user
Common causes include:
- Incorrect username
- Incorrect password
- Wrong authentication method
- Wrong host
- User doesn’t have required privileges
Check the credentials and the MySQL user configuration.
Can’t Connect to MySQL on Port 3306
If you see a connection error, check:
Is MySQL running?
Is MySQL listening on port 3306?
Is the hostname correct?
Is a firewall blocking the connection?
Is MySQL configured to accept the connection?
For local development, try:
localhost
or:
127.0.0.1
Root Password Problems
If you don’t know the root password, don’t repeatedly guess passwords.
The recovery procedure depends on your operating system, MySQL version, authentication configuration, and installation method.
For production databases, password recovery should be performed carefully because changing authentication configuration incorrectly can create security or availability problems.
Should You Use Root for Applications?
No.
The root account is an administrative account.
Your application should normally use a dedicated account:
Application
↓
app_user
↓
myapp database
instead of:
Application
↓
root
↓
Everything
This follows the principle of least privilege.
MySQL Security Best Practices
For production applications:
Use Strong Passwords
Use long, unique passwords.
Create Dedicated Users
Don’t use root for application connections.
Grant Minimum Privileges
Give users only the permissions they actually need.
Don’t Expose MySQL Publicly
Avoid exposing port 3306 directly to the internet unless there is a strong, controlled reason.
Use Encryption
Use TLS for connections that travel across untrusted networks.
Keep MySQL Updated
Apply appropriate security and maintenance updates.
Secure Backups
Protect database backups with appropriate access controls and encryption.
Monitor Database Activity
Watch authentication failures, unexpected connections, and unusual database activity.
MySQL With Node.js
After installing MySQL, you can connect to it from Node.js using a MySQL driver such as mysql2.
Install it:
npm install mysql2
Create a connection pool:
const mysql = require('mysql2/promise');
const pool = mysql.createPool({
host: 'localhost',
user: 'app_user',
password: process.env.DB_PASSWORD,
database: 'myapp'
});
Run a query:
const [rows] = await pool.query(
'SELECT * FROM users WHERE id = ?',
[userId]
);
console.log(rows);
Using placeholders helps prevent SQL injection.
MySQL With Python
Python applications can use MySQL drivers such as MySQL Connector/Python.
Install it with:
pip install mysql-connector-python
Then connect to MySQL using the appropriate host, user, password, and database configuration.
As with Node.js, keep database credentials out of source code.
MySQL With Java
Java applications commonly connect to MySQL using the MySQL Connector/J JDBC driver.
A typical application architecture looks like:
Java Application
↓
JDBC Driver
↓
MySQL
Frameworks such as Spring Boot can configure a MySQL datasource and connection pool automatically.
MySQL vs MySQL Workbench
Remember:
MySQL Server
→ Database engine
MySQL Workbench
→ Graphical database management tool
You need the server to actually store and process your data.
Workbench is optional but useful for administration and development.
MySQL Installation Cheat Sheet
Windows
Download and install MySQL using the official Windows installer.
Verify:
mysql --version
Connect:
mysql -u root -p
macOS
Using Homebrew:
brew install mysql
Start:
brew services start mysql
Verify:
mysql --version
Connect:
mysql -u root -p
Ubuntu/Linux
Update packages:
sudo apt update
Install:
sudo apt install mysql-server
Start:
sudo systemctl start mysql
Verify:
mysql --version
Secure:
sudo mysql_secure_installation
Frequently Asked Questions
Is MySQL free?
MySQL Community Edition is available as an open-source edition. Other MySQL offerings and commercial products may have different licensing and support terms.
What is the default MySQL port?
The default MySQL TCP port is:
3306
Do I need MySQL Workbench?
No.
You can manage MySQL entirely through the command line.
However, Workbench can make database development and administration easier, especially for beginners.
What is the MySQL root user?
root is a highly privileged administrative MySQL account.
It should generally not be used by your application.
How do I check whether MySQL is installed?
Run:
mysql --version
If the command returns a version number, the MySQL client is installed and available through your PATH.
To confirm the server is actually running, connect to it:
mysql -u root -p
How do I check the MySQL version from SQL?
After connecting, run:
SELECT VERSION();
Can I install multiple MySQL versions?
It is possible, but managing multiple server versions on the same machine can create port, service, configuration, and data-directory conflicts.
For development, containers or isolated environments can make version-specific testing easier.
Final Thoughts
Installing MySQL is the first step toward working with relational databases in your applications.
The general process is:
Install MySQL
↓
Start MySQL Server
↓
Verify Installation
↓
Connect to MySQL
↓
Create Database
↓
Create User
↓
Create Tables
↓
Connect Your Application
For Windows, the official installer is usually the simplest approach.
For macOS, Homebrew provides a convenient developer-friendly installation method.
For Linux, the package manager is generally the easiest way to install MySQL, although the exact commands depend on your distribution.
Once MySQL is installed, verify it with:
mysql --version
and connect using:
mysql -u root -p
Then create your first database:
CREATE DATABASE myapp;
For real applications, create a dedicated database user instead of using root, protect your credentials, restrict network access, keep MySQL updated, and use secure connections when communicating across untrusted networks.
With MySQL installed and configured, you’re ready to start building applications that store and manage structured data using SQL.
