Install MySQL on your Windows computer

This guide will help you get MySQL installed on your local windows computer. MySQL is an open source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.

Looking for an install tutorial for Raspberry Pi? Click here

Fetch the installer

To begin, we need to visit the MySQL installer download page here

Run the installer

Once the download is complete, run it. You will be given a License agreement prompt. Check the box that you agree and then click next. The next screen lets you choose which type of setup you want. For our purposes we will leave the default as 'Developer Default' and click next.

Check the requirements

After picking your setup type, the installer will want to make sure you have all the necessary requirements installed. You can click the execute button to check your requirements, and then next when it is complete. It is ok if you don't have some of them installed, such as python or visual studio.

Download the software

Now you should be ready to download all the software needed to install MySQL on your computer. Click execute to start the download, then next once they are all done.

Some configurations

  • Group Replication -> Keep the defaults and click next
  • Type and Networking -> Keep the defaults and click next
  • Authentication Method -> Keep the defaults and click next

Choose a strong password!!

Make your root password as strong as possible. If you want to setup additional users you can do so on this step.

More configurations & Test Connection

There are a series of screens now where you just keep the defaults that are selected and click through (Execute, Next). Once you get to the "Connect to Server" screen, type your password (which you set in one of the steps above) and choose the test connection option. You should see that you are able to connect to your local MySQL server. Click next to move on.

Complete the install

You have a few more configurations screens to click through, and then you are finished! Now you can run the MySQL Workbench and connect to your server. Follow along with the rest of the MySQL tutorials for setting up a database and running queries.