How to Install MySQL on Windows 11

Installing MySQL on your Windows 11 computer involves downloading the MySQL installer, running it, and configuring the MySQL server. Follow these steps to download and install MySQL:

Step 1: Open Google Chrome

  1. Click on the Start menu (Windows icon) at the bottom-left corner of your screen.
  2. Type "Google Chrome" in the search bar.
  3. Click on Google Chrome to open the browser.

Step 2: Go to the MySQL Download Page

  1. In Google Chrome, go to the address bar at the top of the browser window.
  2. Type https://dev.mysql.com/downloads/installer/ and press Enter.

Step 3: Download MySQL Installer

  1. On the MySQL Installer page, scroll down to the MySQL Installer section.
  2. Click on the Download button next to the web community version.
  3. You will be redirected to the download page. Click on No thanks, just start my download.
  4. The download will start automatically. If prompted, click Save to save the installation file to your computer.

Step 4: Run the Installer

  1. Once the download is complete, click on the mysql-installer-web-community-[version].msi file at the bottom of the Google Chrome browser window. If you don’t see it, you can find it in your Downloads folder.
  2. If a User Account Control prompt appears asking if you want to allow this app to make changes to your device, click Yes.

Step 5: Install MySQL

  1. The MySQL Installer will open. On the welcome screen, select Custom and click Next.
  2. In the Select Products and Features window, select the following components:
    • MySQL Server
    • MySQL Workbench
    • MySQL Shell
  3. Click Next to proceed.
  4. In the Check Requirements window, click Execute to install any missing requirements. Click Next once the process is complete.
  5. In the Installation window, click Execute to install the selected products. This may take a few minutes. Click Next once the installation is complete.

Step 6: Configure MySQL Server

  1. In the Product Configuration window, select MySQL Server and click Next.
  2. In the Type and Networking window, select Standalone MySQL Server and click Next.
  3. In the Authentication Method window, select Use Strong Password Encryption for Authentication (RECOMMENDED) and click Next.
  4. In the Accounts and Roles window, set the root password and create a new user if needed. Click Next.
  5. In the Windows Service window, keep the default settings and click Next.
  6. In the Apply Configuration window, click Execute to apply the configuration settings. Click Finish once the process is complete.

Step 7: Complete the Installation

  1. Once the configuration is complete, click Next and then Finish to close the installer.
  2. MySQL Workbench will open automatically. You can use it to manage your MySQL server.

Step 8: Verify the Installation

  1. Open MySQL Workbench from the Start menu.
  2. Click on the Local instance MySQL connection to connect to the MySQL server.
  3. Enter the root password you set during the configuration process.
  4. If you can connect successfully, the installation was successful.

Conclusion

You have successfully installed MySQL on your Windows 11 computer. You can now start using MySQL for database management, development, and other tasks.


Comments

Post a Comment