Upgrading to MySQL 8.0 on macOS

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

Disclaimer:

This content is no longer being updated.

Important:

Different versions of Jamf Pro may have specific MySQL version requirements. To find which version of MySQL is recommended for your version of Jamf Pro, see "System Requirements" in the Jamf Pro Release Notes for your version of Jamf Pro.

Note:

If you are upgrading from MySQL 5.6, you must perform an incremental upgrade to MySQL 5.7 before upgrading to MySQL 8.0. The steps for upgrading from MySQL 5.6 to 5.7 are similar to the steps provided in this article for upgrading from MySQL 5.7 to MySQL 8.0. Perform the steps in this article to upgrade to 5.7, then repeat the steps to upgrade from MySQL 5.7 to MySQL 8.0. For more information, see the following webpage: https://dev.mysql.com/doc/refman/8.0/en/upgrade-paths.html. If you need assistance, contact Jamf Support.

The upgrade process involves the following steps, which are described below:

  1. Preparing to Upgrade

  2. Backing Up the Database

  3. Backing Up the Database Configuration File

  4. Recording Database Settings

  5. Uninstalling MySQL

  6. Installing MySQL 8.0

  7. Configuring the Database

  8. Restoring Database Settings and Custom Settings

  9. Restoring the Database

  10. Disabling Bin Logging

  11. Re-enabling Scheduled Database Backups

  12. Backing Up the Database