Sections:

Installing MySQL 8.0 on Windows 10

Databases allow you to store and retrieve information in an organized manner.

Download

  1. Browse to https://www.mysql.com/downloads/
  2. Click on the MySQL Community (GPL) Downloads link.
  3. Click on the MySQL Installer for Windows link.
  4. Click on the topmost Download button.
  5. Click on the No thanks, just start my download link.

Install

  1. Open the downloaded .msi file to begin the installation process.
  2. Click Yes on the User Access Control (UAC) prompts.
  3. If a "Mandatory MySQL Installer Upgrade Available" message appears. Click Yes to upgrade it.
  4. Choose a Setup Type of "Developer Default"
  5. Click Back.
  6. Change the Setup Type to "Custom"
  7. Click Next.
  8. Remove the following products from installation. Do this by selecting the item in the Products To Be Installed area and clicking on the single left arrow. If the list is blank, please do steps 4 and 5 of the Install section.
    1. MySQL for Visual Studio
    2. MySQL Shell
    3. MySQL Router
    4. Samples and Examples
  9. Click Next.
  10. Click Execute.
  11. After the products are downloaded, click Next.
  12. The status of the products will change to "Ready to Install." Click Execute.
  13. After the products are installed, status will change to "Complete." Click Next.

Configure

  1. Within the MySQL Install, you will see MySQL Server with a status of Ready to configure. Click Next.
  2. Leave the Config type set to "Development Computer." Click Next.
  3. Leave the "User Strong Password Encryption for Authentication" choice set. Click Next.
  4. In the Root Account Password section, enter a MySQL Root Password and repeat the credential in the text field below it.
  5. If you see "Password strength: Weak", add numbers and symbols to the credentials.
  6. Save the credentials in a password manager. The username of this account is root.
  7. In the MySQL User Accounts section, click the Add User button.
  8. Enter a User Name.
  9. Change the Host to localhost.
  10. Enter a Password into the password field. Confirm the credential in the Confirm Password field.
  11. If you see "Password strength: Weak", add numbers and symbols to the credentials.
  12. Save the credentials in a password manager. These are the credentials that you will use in your application.
  13. Click OK.
  14. Click Next.
  15. In the Windows Service section, click Next.
  16. In the Server File Permissions section, click Next.
  17. Click Execute.
  18. Click Finish.
  19. MySQL Server shows a status of "Configuration complete." Click Next.
  20. Click Finish.

Test the Connection

If MySQL Workbench does not automatically start, click Search and type MySQL Workbench. Click on the MySQL Workbench 8.0 CE icon.

  1. Since "Start MySQL Workbench after setup" was checked, the MySQL Workbench application will start.
  2. Under the MySQL Connections section, click on Local instance MySQL80.
  3. Enter the root credentials into the password field.
  4. Check Save password in vault.
  5. Click OK.

Create a Database Schema

  1. Locate the Navigator pane on the left side of the window.
  2. At the bottom of the Navigator pane, click on Schemas.
  3. Right-click in the blank area inside of the Navigator pane.
  4. Click Create Schema...
  5. Enter in the name of the database schema that you want to create.
  6. Click on the Apply button that appears at the bottom of that pane.
  7. In the Apply SQL Script to Database window, click Apply.
  8. Click Finish.
  9. Close MySQL workbench.