Video summary

How to install MySQL 8.0.40 Server and Workbench latest version on Windows 11

Main summary

Key takeaways

Product Review

Product Reviewed

MySQL 8.0.40 Server + MySQL Workbench/related tools on Windows 11 (installation and initial setup).

The video demonstrates how to download, install, configure, and verify MySQL, and then add Workbench and MySQL Shell.

Key Features / What’s Included (from the Video)

Installer

  • MySQL Installer for Windows (from the official MySQL Community downloads page)

Components Installed

The installer installs three components:

  • MySQL Server
  • MySQL Workbench
  • MySQL Shell

Configuration During Install

  • Uses setup type = Custom
  • Keeps default networking settings with port 1306
  • Keeps authentication on the default recommended option: Strong password
  • Leaves Windows service at its default
  • Keeps default server file permissions/location (saved in the shown Program Files path)

Post-Install Steps

  • Adds the MySQL Server bin path to the Windows PATH via Environment Variables
  • Verifies installation using:
    • mysql --version
  • Starts server and logs in using:
    • mysql -u root -p
  • Demonstrates basic database management:
    • SHOW DATABASES;
    • CREATE DATABASE AmitDB;
  • Highlights Workbench as a GUI option so users can manage databases without typing commands

Pros (User Experience / Benefits Mentioned)

  • End-to-end setup is straightforward: download → select components → install → configure → verify
  • Custom install enables installing Server + Workbench + Shell together
  • Workbench UI is emphasized as convenient for users who don’t want to type SQL
  • Includes helpful verification steps (version check, login, create DB) to confirm the install worked

Cons / Potential Issues Mentioned

  • The video includes manual steps beyond the installer:
    • Set PATH to include the MySQL Server bin directory
  • Users must remember the root/admin password since it’s manually set during setup

Comparisons Made

  • No direct comparisons to other database tools (e.g., PostgreSQL or SQL Server) are mentioned.
  • The only selection guidance mentioned is choosing the correct Windows installer:
    • Advises selecting the second option (shown as 306 MB) which supports both 32-bit and 64-bit Windows.

Unique Points Mentioned (Complete List)

  1. Install the current MySQL version on Windows 11 and create a sample database
  2. Download from official MySQL Community downloads
  3. Choose the MySQL installer for Windows and select the second option (306 MB)
  4. Use “No thanks” / start download
  5. In the installer, choose Custom setup
  6. Select/install MySQL Server, MySQL Workbench, and MySQL Shell
  7. Configure:
    • Default networking, port 1306
    • Authentication: Strong password
    • Set root/admin password
    • Keep Windows service default
    • Keep server file permissions default
  8. After installation, Workbench and Shell start automatically
  9. Add MySQL Server bin path to Windows PATH via Environment Variables
  10. Verify with mysql --version → confirms 8.0.4 installed
  11. Start/login with mysql -u root -p
  12. View default DBs with SHOW DATABASES;
  13. Create sample DB: CREATE DATABASE AmitDB;
  14. Suggest using Workbench UI instead of commands
  15. Mentions free tutorials for MySQL and Workbench via links in the video description

Speakers / Perspectives

  • Single speaker (“Amit things” / tutorial narrator): provides all steps and instructions.
  • No separate viewpoints are presented.

Verdict / Recommendation

Recommended if you want a guided, step-by-step MySQL 8.0.40 (8.0.4 shown in the transcript) + Workbench on Windows 11 setup.

The video is particularly helpful for beginners because it includes verification steps (version check, login, database creation) and a key reminder to set the PATH.

Original video