Installing MySQL Community Server 8.0 on Windows

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US

Follow these steps to perform a basic installation of MySQL Community Server on Windows. Your organization may require different configuration settings for security or other reasons. Consult your IT department for more information about how MySQL should be configured.

  1. Download the web or full MySQL installer for Windows ("Windows (x86, 32-bit), MSI Installer") from the following webpage:

    https://dev.mysql.com/downloads/windows/installer/8.0.html

    Note:

    The installer is 32-bit but it supports both 32-bit and 64-bit MySQL binaries.

  2. Open the MySQL installer.
  3. Select the Server Only setup type, and click Next.
  4. The installer will verify that the required software is installed. If the Microsoft Visual C++ Redistributable needs to be installed, click Execute to initiate the installation of this required software. Perform the installation of the software before continuing, and then click Next in the MySQL installer to continue.
  5. Start the installation of MySQL by clicking Execute, and click Next when the installation is complete.
  6. Click Next to begin the configuration.
  7. Click the Config Type pop-up menu and choose the option that is applicable to your environment.
    Important:

    For production environments, the "Development Computer" option should never be selected.

  8. Click Next.
  9. Select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility), and click Next.
  10. In the "Accounts and Roles" window, create a password for the root user by entering it in the MySQL Root Password field and confirming it in the Repeat Password field.
    Important:

    Make a careful note of your MySQL root password. It can become useful in troubleshooting situations.

  11. Click Next.
  12. Ensure Configure MySQL Server as a Windows Service, Start the MySQL Server at System Startup, and Standard System Account are selected, and click Next.
  13. Ensure Yes, grant full access to the user running the Windows Service (if applicable) and the administrators group only. Other users and groups will not have access. is selected, and then click Next.
  14. Click Execute to apply the configuration and then click Finish when the configuration is complete.
  15. Click Next and then click Finish to complete the installation and exit the installer.
  16. Configure MySQL 8.0 to be compatible with Jamf Pro.

    For instructions, see the Configuring MySQL 8.0 for Jamf Pro article.