This article shows how to install MySQL Server on a computer with the Windows 10 operating system. In order to install and use MySQL on a Windows platform, the Python programming language version 2.7 must be present (do not install Python 3 or a later version because it does not supports MySQL).
Steps
Part 1 of 3: Install Python
Step 1. Go to the Python website and downloads page
Use the internet browser of your choice and the following URL:
Step 2. Select the Download link for Python version 2.7.14
Do not use the yellow download button at the top of the page as it is reserved for downloading the latest version of Python available. Remember that Python version 2.7.14 is the one that will allow you to use MySQL without problems.
Unfortunately it is not possible to use MySQL using Python 3
Step 3. Double click on the Python installation file
Normally, by default, it is automatically saved in the folder reserved for downloads of the internet browser in use. This will start the installation of the program.
Step 4. Follow the instructions given to you by the installation wizard
In the case of Python, the installation procedure is very simple and intuitive:
- Push the button Next located in the first screen of the procedure;
- Push the button Next relative to the "Select Destination Directory" screen;
- Push the button Next for the "Customize" screen.
Step 5. Press the Yes button when prompted
This will begin installing Python on your computer.
This step should only take a few seconds to complete
Step 6. At the end of the installation press the Finish button
It will be displayed upon completion of the process within the last screen of the installation wizard. Now that Python version 2.7 is installed on your system you can proceed to install the MySQL server.
Part 2 of 3: Install MySQL
Step 1. Log in to the MySQL Server website
Use the browser of your choice and the following URL: https://dev.mysql.com/downloads/windows/installer/8.0.html. You will be automatically redirected to the download page for the installation file of the latest available version of MySQL.
Step 2. Press the Download button
It is blue in color and is positioned at the bottom of the web page that appears.
There should be two installation files related to the Windows operating system, so be sure to select the button Download located lower and not the upper one (to avoid mistakes, download the installation file with the largest size).
Step 3. Scroll down the new page to locate and select the No thanks, just start my download link
It is placed at the end of the page. The MySQL installation file will be downloaded to your computer.
Step 4. Double-click the file you just downloaded
This will start the MySQL installation wizard.
Step 5. Press the Yes button when prompted to confirm your willingness to proceed with the MySQL installation
The relevant installation window will appear.
You may need to perform this step twice before you can continue
Step 6. Select the "I accept the license terms" check button
It is located in the lower left part of the installation window.
Step 7. Press the Next button
It is located in the lower right part of the installation wizard window.
Step 8. Select the "Full" installation option
It is positioned in the center of the page.
Step 9. Press the Next button
It is located at the bottom right of the screen. This will save the installation settings.
Step 10. Press the Next button located inside the "Requirements" screen
It is located at the bottom of the window.
Step 11. Now press the Execute button
The latter is also located in the lower right part of the window. The installation of MySQL Server on your computer will begin.
Step 12. Wait for the MySQL installation to complete
When all the items listed in the "Installation" screen have been marked with a check mark, you can proceed with the MySQL configuration.
Part 3 of 3: Setting up MySQL
Step 1. Follow the instructions for the program setup wizard
The first five screens of the MySQL setup procedure contain default configuration settings that are optimized for most Windows systems, so you can quickly scroll through them simply by following these instructions:
- At the end of the installation press the button Next;
- When you get to the MySQL configuration screen, press the button Next;
- Push the button Next relative to the "Group Replication" page;
- Now press the button Next located within the "Type and Networking" screen;
- At this point, press the button Next placed in the "Authentication Method" page.
Step 2. Create the MySQL server login password
Type your preferred password into the "MySQL Root Password" text field, then type a second time using the "Repeat Password" field.
Step 3. Add the server administrator account
This will be the user account that will allow you to manage the MySQL server and perform normal tasks such as adding user profiles, changing login passwords, and so on (this is not the root account):
- Select the option Add User located in the lower right part of the screen;
- Type the username you want to assign to the account using the "Username" text field;
- Make sure that the entry is displayed in the "Role" text field DB Admin. Otherwise go to the "Role" drop-down menu and select the option DB Admin;
- Enter the access password you prefer using the "Password" and "Confirm Password" text fields;
- When finished, press the button OK.
Step 4. Press the Next button
It is located at the bottom of the page. This will create the user account with the specified login password.
Step 5. Press the Next button
It is located at the bottom of the "Windows Service" screen.
Step 6. Enable archiving and indexing of documents within MySQL
This step is optional and can be skipped by pressing the button Next. If, on the other hand, it is a feature you want to activate, follow these instructions:
- Select the check button "Enable X Protocol / MySQL as a Document Store";
- If necessary, change the number of the communication port;
- Make sure the "Open Windows Firewall port for network access" checkbox is checked;
- At this point, press the button Next.
Step 7. Press the Execute button
It is located at the bottom of the window. The MySQL installation wizard will configure the server according to the specified settings.
Step 8. Press the Finish button
The latter will be made available as soon as the MySQL server configuration is complete.
Step 9. Continue configuring the MySQL server
Push the button Next located at the bottom of the window, then press the button Finish. This will give you access to the final part of the MySQL configuration which consists of connecting directly to the server.
Step 10. Enter the root password you set at the beginning of the setup procedure
Use the "Password" text field at the bottom of the window.
Step 11. Press the Check button
It is located at the bottom of the page. In this way, the correctness of the password entered will be verified and, if successful, you can continue.
Step 12. Press the Next button
Again it is positioned at the bottom of the screen.
Step 13. Press the Execute button
At this point the MySQL server will be configured according to the parameters indicated in this last part.
Step 14. Complete the program setup
Press the buttons in succession Finish And Next located at the bottom of the "Product Configuration" page, then press the button Finish which will appear in the lower right corner of the window. This way your MySQL server configuration will be complete and the MySQL command console (Shell) and dashboard will be displayed. At this point you are ready to start using your MySQL server.
