How to Install MySQL on Windows

How to Install MySQL on Windows – Step-by-Step Guide for FYBSc IT DBMS Practical

Are you a first-year BSc IT student looking for an easy way to install MySQL on your Windows computer for your DBMS practicals? In this guide, we’ll walk you through the exact steps to download and install MySQL on Windows, ensuring a smooth setup for your database management tasks.

What is DBMS?

A Database Management System (DBMS) is software that helps you store, manage, and retrieve data in an organized way. It allows users to create databases, define relationships, and perform CRUD operations (Create, Read, Update, Delete) easily using SQL commands. MySQL is one of the most popular DBMS used in industry and education.

Step 1: Download MySQL Installer for Windows

First, visit the official MySQL Downloads page. You will see two installer options:

  • MySQL Installer Web Community
  • MySQL Installer Full

For most practical purposes, the web community installer is sufficient.
👉 Click the "Download" button next to MySQL Installer for Windows.

Step 2: Run the Installer

Once the installer file is downloaded (usually named mysql-installer-community-x.x.xx.x.msi), follow these steps:

  1. Double-click the installer file to launch the installation wizard.
  2. Choose the Setup Type – for beginners, select the Developer Default option. This installs MySQL Server, MySQL Workbench, and other necessary tools.
  3. Click Next and follow the prompts.

Step 3: Configure MySQL Server

During the installation process, you will need to configure MySQL Server:

  • Set the root password – remember this password for later use.
  • Configure MySQL as a Windows Service so it starts automatically.
  • Optionally, add user accounts if required by your course instructor.

Step 4: Complete Installation

After configuration, the installer will proceed to download and install all required components. Once the process is complete:

  • Launch MySQL Workbench to manage your databases using a graphical interface.
  • Use Command Line Client for direct SQL query execution.

Step 5: Verify Installation

To verify that MySQL is properly installed:

  1. Open Command Prompt.
  2. Type mysql -u root -p and press Enter.
  3. Enter the root password you configured.
  4. You should see the MySQL command line interface, confirming a successful installation.

Watch Full Video Tutorial

If you prefer a visual step-by-step tutorial, watch my full video here:
▶️ How to Install MySQL on Windows – FYBSc IT DBMS Practical

Conclusion

Installing MySQL on Windows is easy and essential for your DBMS practicals in FYBSc IT. By following this guide, you’ll be ready to create databases, practice SQL commands, and complete your course assignments confidently.

👉 Don’t forget to like, share, and subscribe if this helped you!

🔗