How to Install the MySQL Database Server on Your Windows PC

Written by Jack Lloyd

Last Updated: November 3, 2022 Tested

This wikiHow teaches you how to install the MySQL Server program on a Windows 10 computer. In order to install MySQL on a Windows computer, you must first have Python 2.7 (not Python 3+) installed.

Part 1

Part 1 of 3:

Installing Python

Go to https://www.python.org/downloads in your computer's web browser.
2
Click Download Python 2.7.14 . It's a yellow button at the top of the page. Python version 2.7.14 is the version that you'll need to use for MySQL.
- You cannot run MySQL using Python 3.
Advertisement
You'll find it in your browser's default downloads location. Doing so opens the Python setup window.
4
Navigate through the Python installation. The Python setup process is fairly straightforward:
- Click Next on the first page.
- Click Next on the "Select Destination Directory" page.
- Click Next on the "Customize" page.
5
Click Yes when prompted. Doing so will cause Python to begin installing.
- The Python installation should only take a few seconds.
This option appears when Python has been installed successfully. Now that Python 2.7 is installed, you can proceed with installing MySQL.

Advertisement

Part 2

Part 2 of 3:

Installing MySQL

Go to https://dev.mysql.com/downloads/windows/installer/8.0.html in your computer's web browser. This will take you to the download site for the community version of MySQL Server.
2
Click the bottom Download option. This blue button is at the bottom of the page.
- Make sure to click the bottom Download button and not the top one here.
It's a link near the bottom of the page. The MySQL setup file will download onto your computer.
Doing so prompts the MySQL setup window to open.
5
Click Yes when prompted. This will confirm that you want to proceed with installing MySQL, which will open the MySQL launcher window.
- You may have to do this twice before proceeding.
It's in the bottom-left side of the launcher window.
This is at the bottom of the window.
It's in the middle of the page.
This option is at the bottom of the page. Doing so will save your installation preferences.
It's at the bottom of the page.
This button is at the bottom of the window. Doing so will prompt MySQL to begin installing onto your computer.
Once each of the options in the "Installation" window have checkmarks next to them, you can proceed with setting up MySQL.

Advertisement

Part 3

Part 3 of 3:

Setting up MySQL

1
Navigate through the first few pages. The first five pages of the MySQL setup are optimized for most Windows computers, so you can just click through them:
- Click Next when the installation completes.
- Click Next on the configuration page.
- Click Next on the "Group Replication" page.
- Click Next on the "Type and Networking" page.
- Click Next on the "Authentication Method" page.
Type your preferred password into the "MySQL Root Password" text box, then re-enter the password in the "Repeat Password" text box.
3
Add an administrator account. This will be the non-root account that you can use to do things like add users, change passwords, and so on:
- Click Add User in the lower-right side of the page.
- Type in your preferred username in the "Username" field.
- Make sure that the "Role" field has DB Admin selected; if it doesn't, click the "Role" drop-down box and then click DB Admin
- Enter a unique password for the user in the "Password" and "Confirm Password" boxes.
- Click OK
This is at the bottom of the page. Doing so confirms your password and user account.
It's at the bottom of the "Windows Service" page.
6
Enable MySQL as a document store. You can skip this step by clicking Next if you like. Otherwise, do the following:
- Check the "Enable X Protocol / MySQL as a Document Store" box.
- Change the port number if necessary.
- Make sure that the "Open Windows Firewall port for network access" box is checked.
- Click Next
It's at the bottom of the window. Your MySQL installation will begin configuring itself.
This option will become available when the configuration is complete.
Click Next at the bottom of the window, then click Finish . This will bring you to the final part of MySQL's setup, which is connecting to the server itself.
In the "Password" box near the bottom of the window, type in the password that you created at the beginning of this part.
It's at the bottom of the page. This will check your password and, if the password is correct, allow you to proceed.
This option is at the bottom of the page.
Doing so will configure this part of your installation.
Click Finish , click Next at the bottom of the "Product Configuration" page, and click Finish in the bottom-right corner of the window. This will complete your MySQL setup and open the MySQL Shell and dashboard. You're now ready to begin using MySQL.

Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Tips

If you want to install the Apache/PHP/MySQL combo on Windows, you can use XAMPP in conjunction with your MySQL server.

Thanks
Helpful 0 Not Helpful 0

Warnings

If you have Python 3 installed, MySQL will not recognize it as a valid source. You need to have Python 2.7 installed in order for MySQL to be properly configured.

Thanks
Helpful 2 Not Helpful 0

How to Install the MySQL Database Server on Your Windows PC

Steps

Installing Python

Installing MySQL

Setting up MySQL

Expert Q&A

Tips

Warnings

You Might Also Like

About this article

Reader Success Stories

Is this article up to date?

You Might Also Like

Explore Categories