Upgrading to MySQL 8.0 on Ubuntu

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US
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. Stopping Tomcat

  3. Backing Up the Database

  4. Backing Up the Database Configuration File

  5. Recording Database Settings

  6. Uninstalling MySQL

  7. Installing MySQL 8.0

  8. Configuring the Database

  9. Restoring Database Settings and Custom Settings

  10. Restoring the Database

  11. Disabling Bin Logging

  12. Re-enabling Scheduled Database Backups

  13. Backing Up the Database