How to Install the MySQL Database Server on Your Windows PC

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. Open the Python download page. Go to...

Part 1 of 3:

Installing Python

  1. Picture 1 of How to Install the MySQL Database Server on Your Windows PC
    Open the Python download page. Go to https://www.python.org/downloads in your computer's web browser.
  2. Picture 2 of How to Install the MySQL Database Server on Your Windows PC
    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.
    1. You cannot run MySQL using Python 3.
  3. Picture 3 of How to Install the MySQL Database Server on Your Windows PC
    Double-click the Python setup file. You'll find it in your browser's default downloads location. Doing so opens the Python setup window.
  4. Picture 4 of How to Install the MySQL Database Server on Your Windows PC
    Navigate through the Python installation. The Python setup process is fairly straightforward:
    1. Click Next on the first page.
    2. Click Next on the "Select Destination Directory" page.
    3. Click Next on the "Customize" page.
  5. Picture 5 of How to Install the MySQL Database Server on Your Windows PC
    Click Yes when prompted. Doing so will cause Python to begin installing.
    1. The Python installation should only take a few seconds.
  6. Picture 6 of How to Install the MySQL Database Server on Your Windows PC
    Click Finish. This option appears when Python has been installed successfully. Now that Python 2.7 is installed, you can proceed with installing MySQL.
Score
0 / 0

Part 1 Quiz

Which version of Python do you need to download before you can install the MySQL Database Server?

Not quite! You cannot use any version of Python to run MySQL. You should make sure you download the correct version of Python so that you can correctly install and use MySQL. Choose another answer!

Not exactly! You should avoid downloading Python 3.3.7 as it will not work correctly. You need the correct version of Python that allows you to install and use MySQL or you will have to navigate back to the Python downloader and try again. Choose another answer!

Yes! Python 2.7.14 is the correct version to download. Using 2.7.14, you'll be able to install MySQL and use it correctly. Read on for another quiz question.

Want more quizzes?

Keep testing yourself!
Part 2 of 3:

Installing MySQL

  1. Picture 7 of How to Install the MySQL Database Server on Your Windows PC
    Open the MySQL Server download page. 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. Picture 8 of How to Install the MySQL Database Server on Your Windows PC
    Click the bottom Download option. This blue button is at the bottom of the page.
    1. Make sure to click the bottom Download button and not the top one here.
  3. Picture 9 of How to Install the MySQL Database Server on Your Windows PC
    Scroll down and click No thanks, just start my download. It's a link near the bottom of the page. The MySQL setup file will download onto your computer.
  4. Picture 10 of How to Install the MySQL Database Server on Your Windows PC
    Double-click the setup file. Doing so prompts the MySQL setup window to open.
  5. Picture 11 of How to Install the MySQL Database Server on Your Windows PC
    Click Yes when prompted. This will confirm that you want to proceed with installing MySQL, which will open the MySQL launcher window.
    1. You may have to do this twice before proceeding.
  6. Picture 12 of How to Install the MySQL Database Server on Your Windows PC
    Check the "I accept the license terms" box. It's in the bottom-left side of the launcher window.
  7. Picture 13 of How to Install the MySQL Database Server on Your Windows PC
    Click Next. This is at the bottom of the window.
  8. Picture 14 of How to Install the MySQL Database Server on Your Windows PC
    Check the "Full" box. It's in the middle of the page.
  9. Picture 15 of How to Install the MySQL Database Server on Your Windows PC
    Click Next. This option is at the bottom of the page. Doing so will save your installation preferences.
  10. Picture 16 of How to Install the MySQL Database Server on Your Windows PC
    Click Next on the "Requirements" page. It's at the bottom of the page.
  11. Picture 17 of How to Install the MySQL Database Server on Your Windows PC
    Click Execute. This button is at the bottom of the window. Doing so will prompt MySQL to begin installing onto your computer.
  12. Picture 18 of How to Install the MySQL Database Server on Your Windows PC
    Wait for MySQL to finish installing. Once each of the options in the "Installation" window have checkmarks next to them, you can proceed with setting up MySQL.
Score
0 / 0

Part 2 Quiz

Why should you click "Yes" on the pop-up screen after you double click the setup file?

Not quite! Clicking "Yes" on the pop-up screen does not automatically accept the license terms. Instead, you will have the option to accept the license terms when you reach the launcher window. You are required to accept these terms to move forward with the install. Choose another answer!

Yup! At this step, you are confirming that you are OK with proceeding to the installation. After you click "Yes" the MySQL launcher window will open. Read on for another quiz question.

Not exactly! Choosing "Yes" won't open the setup window. At this point in the process, you have already opened the setup window. Choose another answer!

Want more quizzes?

Keep testing yourself!
Part 3 of 3:

Setting up MySQL

  1. Picture 19 of How to Install the MySQL Database Server on Your Windows PC
    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:
    1. Click Next when the installation completes.
    2. Click Next on the configuration page.
    3. Click Next on the "Group Replication" page.
    4. Click Next on the "Type and Networking" page.
    5. Click Next on the "Authentication Method" page.
  2. Picture 20 of How to Install the MySQL Database Server on Your Windows PC
    Create a MySQL password. Type your preferred password into the "MySQL Root Password" text box, then re-enter the password in the "Repeat Password" text box.
  3. Picture 21 of How to Install the MySQL Database Server on Your Windows PC
    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:
    1. Click Add User in the lower-right side of the page.
    2. Type in your preferred username in the "Username" field.
    3. 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
    4. Enter a unique password for the user in the "Password" and "Confirm Password" boxes.
    5. Click OK
  4. Picture 22 of How to Install the MySQL Database Server on Your Windows PC
    Click Next. This is at the bottom of the page. Doing so confirms your password and user account.
  5. Picture 23 of How to Install the MySQL Database Server on Your Windows PC
    Click Next. It's at the bottom of the "Windows Service" page.
  6. Picture 24 of How to Install the MySQL Database Server on Your Windows PC
    Enable MySQL as a document store. You can skip this step by clicking Next if you like. Otherwise, do the following:
    1. Check the "Enable X Protocol / MySQL as a Document Store" box.
    2. Change the port number if necessary.
    3. Make sure that the "Open Windows Firewall port for network access" box is checked.
    4. Click Next
  7. Picture 25 of How to Install the MySQL Database Server on Your Windows PC
    Click Execute. It's at the bottom of the window. Your MySQL installation will begin configuring itself.
  8. Picture 26 of How to Install the MySQL Database Server on Your Windows PC
    Click Finish. This option will become available when the configuration is complete.
  9. Picture 27 of How to Install the MySQL Database Server on Your Windows PC
    Configure the next attribute. 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.
  10. Picture 28 of How to Install the MySQL Database Server on Your Windows PC
    Enter your root password. In the "Password" box near the bottom of the window, type in the password that you created at the beginning of this part.
  11. Picture 29 of How to Install the MySQL Database Server on Your Windows PC
    Click Check. It's at the bottom of the page. This will check your password and, if the password is correct, allow you to proceed.
  12. Picture 30 of How to Install the MySQL Database Server on Your Windows PC
    Click Next. This option is at the bottom of the page.
  13. Picture 31 of How to Install the MySQL Database Server on Your Windows PC
    Click Execute. Doing so will configure this part of your installation.
  14. Picture 32 of How to Install the MySQL Database Server on Your Windows PC
    Finish the product configuration. 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.
Score
0 / 0

Part 3 Quiz

True or false: You'll need to create two separate passwords when you're installing MySQL.

Correct! To get the most function out of MySQL, you will need to start with two accounts and two separate passwords. The first account is your user account and the second is an admin account. The admin account is responsible for adding users and changing passwords. Read on for another quiz question.

Nope! You will create two separate accounts during the MySQL installation. The first is your user account and the second is your admin account. Both accounts will have their own password. Try again...

Want more quizzes?

Keep testing yourself!
Update 05 March 2020
clickmysqlpythonpage

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile