This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article meets our high standards.

The wikiHow Tech Team also followed the article's instructions and validated that they work.
Learn more...

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.

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

4

Click Next. This is at the bottom of the page. Doing so confirms your password and user account.

5

Click Next. 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

7

Click Execute. It's at the bottom of the window. Your MySQL installation will begin configuring itself.

8

Click Finish. This option will become available when the configuration is complete.

9

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

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

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

Click Next. This option is at the bottom of the page.

13

Click Execute. Doing so will configure this part of your installation.

14

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.

Article Info

This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article meets our high standards.