How to Install MySQL v8.0.46 on Windows 10/11 (2026) | Step-by-Step Guide

Below is a step-by-step guide to install MySQL v8.0.46 on Windows 10/11.

Step 1: Download MySQL Installer

  1. Go to the official site: https://www.mysql.com/
  2. Click on Downloads menu.
  3. Click on MySQL Community (GPL) Downloads under MySQL Community Edition.
  4. Click on MySQL Installer for Windows.
  5. Download: Windows (x86, 32-bit), MSI Installer (mysql-installer-community-8.0.46.0.msi) for offline installation.
  6. Click on No thanks, just start my download.

Step 2: Run the Installer

  1. Double-click the downloaded mysql-installer-community-8.0.46.0.msi file.
  2. If Windows asks permission, click Yes.
  3. Select Setup Type: Full and click Next.
  4. The installer will install:
    • MySQL Server
    • MySQL Workbench
    • MySQL Shell
    • MySQL Router
    • MySQL Documentation
    • Samples and Examples
  5. Click Execute and wait for installation to complete.
  6. Click Next.

Step 3: Configure MySQL Server

  1. Click Next.
  2. Keep Type and Networking Configuration default and click Next.
  3. Keep Authentication settings default and click Next.
  4. Set a strong root password.
  5. Enter password in MySQL Root Password.
  6. Confirm password and click Next.
  7. Select Configure MySQL Server as a Windows Service.
  8. Service Name: MySQL80 (default).
  9. Enable Start MySQL Server at System Startup.
  10. Click Next.
  11. Click Execute and wait for all steps to succeed.
  12. Click Finish.

Step 4: Configure MySQL Router & Samples

  1. Click Next.
  2. Keep default settings and click Finish.
  3. Click 'Next'.
  4. Enter root password and click Check.
  5. Confirm “Connection Succeeded”.
  6. Click Next → Execute.
  7. Wait for success and click Finish.
  8. Click 'Next' and then Click 'Finish'.

Step 5: Launch MySQL Workbench

  1. Open MySQL Workbench from Start Menu.
  2. Click Local instance MySQL80.
  3. Enter root password and click OK.
  4. Run:
    SELECT VERSION();

Step 6: Launch MySQL Shell

  1. Run command:
    \connect root@localhost
  2. Enter password.
  3. Press N if prompted.
  4. Switch to SQL mode:
    \sql
  5. Run:
    SELECT VERSION();

Step 7: Launch MySQL Command Line Client

  1. Enter password.
  2. Run:
    SELECT VERSION();

Step 8: Add MySQL to PATH

  1. Press Win + R, type:
    sysdm.cpl
  2. Go to Advanced tab.
  3. Click Environment Variables.
  4. Select Path under System variables → click Edit.
  5. Click New and add:
    C:\Program Files\MySQL\MySQL Server 8.0\bin
  6. Click OK → OK → OK.

Step 9: Verify Installation

  1. Open Command Prompt.
  2. Run:
    mysql -u root -p
  3. Enter password.
  4. Run:
    SELECT VERSION();

Comments

Popular posts from this blog

How to Install Geany 2.1 on Windows 10/11 (2026) | Step-by-Step Guide

How to Install Anaconda v2025.12-2 on Windows 10/11 (2026) | Step-by-Step Guide

How to Install Miniconda on Windows 10/11 (2026) | Step-by-Step Guide