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 NextExecute.
  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 Uninstall Bluefish 2.2.19 on Windows 10/11 (2026) | Step-by-Step Guide

How to Install Visual Studio 2026 on Windows 10/11 | Step-by-Step Guide