How to Install MySQL on Windows: Step-by-Step Guide

To install MySQL on Windows, download the MySQL Installer from the official website, run it, and follow the setup wizard to choose your preferred configuration. After installation, you can start the MySQL server and connect using the MySQL Command Line Client or Workbench.

Syntax

Installing MySQL on Windows involves running the MySQL Installer executable and following the setup steps. The main parts include:

• Download: Get the installer from the official MySQL website.
• Run Installer: Launch the downloaded file to start the setup wizard.
• Choose Setup Type: Select Typical, Minimal, or Custom installation.
• Configure Server: Set root password and other options.
• Complete Installation: Finish and start MySQL server.

text

1. Download MySQL Installer from https://dev.mysql.com/downloads/installer/
2. Run the installer executable (e.g., mysql-installer-community.exe)
3. Follow the wizard steps:
   - Choose setup type (Typical recommended)
   - Select products and features
   - Configure MySQL server (set root password)
   - Apply configuration
4. Finish installation and launch MySQL server

Example

This example shows the key steps after downloading the MySQL Installer to install MySQL Server with default settings and set a root password.

text

1. Double-click <code>mysql-installer-community.exe</code> to start.
2. Select <strong>Typical</strong> setup and click <strong>Next</strong>.
3. Click <strong>Execute</strong> to download and install required components.
4. When prompted, set a strong root password and remember it.
5. Click <strong>Finish</strong> to complete installation.
6. Open <code>MySQL Command Line Client</code> and log in with root password:

mysql -u root -p

7. Run a test query:

SHOW DATABASES;

Output

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

Common Pitfalls

Some common mistakes when installing MySQL on Windows include:

• Not running the installer as Administrator, causing permission errors.
• Forgetting to set or remember the root password, which blocks access.
• Choosing a custom setup without required components like MySQL Server or Workbench.
• Firewall blocking MySQL server port (3306), preventing connections.
• Confusing 32-bit and 64-bit installer versions for your system.

Always verify your Windows version and run the installer with admin rights.

text

/* Wrong: Running installer without admin rights */
// May cause errors during installation

/* Right: Run installer as Administrator */
// Right-click installer > Run as Administrator

Quick Reference

Step	Description
Download Installer	Get from https://dev.mysql.com/downloads/installer/
Run Installer	Launch the .exe file as Administrator
Choose Setup Type	Typical is recommended for beginners
Configure Server	Set root password and default settings
Finish Installation	Complete and start MySQL server
Test Connection	Use MySQL Command Line Client or Workbench

Key Takeaways

Download the official MySQL Installer for Windows from the MySQL website.

Run the installer as Administrator to avoid permission issues.

Choose Typical setup for an easy installation with default components.

Set and remember a strong root password during configuration.

Test your installation by logging into MySQL and running a simple query.