How to Install MySQL on Windows

Steps to Download MySQL

1. Search for MySQL Downloads

   • Open your browser and search for MySQL downloads
   • You'll land on the MySQL downloads page

2. Go to MySQL Community GPL Downloads

   • Click on MySQL Community GPL Downloads (GPL stands for General Public License)

3. Download MySQL Community Server

   • Choose MySQL Community Server
   • Go to the download page

Installing MySQL

1. Choose Installation Method

   • You have two options:
     • Just an installer
     • Download MySQL in one go
   • Preferred: Download the installer
   • Click No thanks, just start my download (No need to log in or sign up)

2. Run the Installer

   • Find the downloaded installer in your folder
   • Double-click the installer
   • Click Yes when prompted

3. Installation Process

   • Choose setup type: Default (Developer Default)
   • Click Next
   • If there is an error, click Try Again
   • Click Next to proceed to product configuration

Configuration Steps

1. Set Up Password

   • Use a strong and easy-to-remember password
   • Enter the password
   • Click Next

2. Service Name and Settings

   • Leave settings as default
   • Click Next

3. Apply Configuration

   • Click Execute to apply the changes
   • Click Finish after all configurations are applied

Final Steps

1. Product Configuration

   • Click Next, keep the default settings
   • Enter the password again
   • Click Check to establish connection
   • Click Next and Execute
   • Click Finish

2. Completion

   • Installation complete
   • Click Finish

Testing MySQL

1. Command Line Client
   • Open MySQL 8.0 Command Line Client
   • Enter your password
   • Run queries, e.g., SHOW DATABASES
   • Check the default databases

Note: MySQL Community Server GPL version 8.0 is installed and running.

Conclusion

• MySQL installation is complete and verified to be working.
• Subscribe for more tutorials!