Skip to main content
Jamf Nation, hosted by Jamf, is the largest Apple IT management community in the world. Dialog with your fellow IT professionals, gain insight about Apple device deployments, share best practices and bounce ideas off each other. Join the conversation.

Configuring MySQL 8.0 for Jamf Pro

Overview

This article describes how to configure MySQL 8.0 for Jamf Pro. MySQL 8.0 uses a default user authentication plug-in (caching_sha2_password) that is not supported by Jamf Pro. To use MySQL 8.0 with Jamf Pro, you must configure the MySQL authentication plug-in to use legacy password encryption.

For more information about the user authentication plug-in, see the following webpage:
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password

For information about upgrading to MySQL 8.0, see the following webpage:
https://dev.mysql.com/doc/refman/8.0/en/upgrading.html

Setting the --log-bin Option for Replication or Point-in-Time Recovery

The --log-bin option is used for replication and point-in-time recovery. With MySQL 8.0, the default setting for the --log-bin option has changed from OFF to ON.

  • If you use replication or point-in-time recovery: Make sure that the new default setting is appropriate for your environment.
  • If you do not use replication or point-in-time recovery: It is recommended that you change the --log-bin option to OFF to prevent extra disk space from being used.

For more information, see the following webpages:

Versions Affected

Jamf Pro 10.10.0 or later

Procedures

Follow the instructions below to set the default authentication plug-in to mysql_native_password or Legacy Password Encryption method.

Linux

You can change the default user password authentication plug-in after MySQL 8.0 installation.

  1. Stop the MySQL server.
  2. Open the my.cnf file.
  3. Add the following entry:
    [mysqld]
    default-authentication-plugin=mysql_native_password
  4. Restart the MySQL server.

Mac

You can change the default user password authentication plug-in during or after MySQL 8.0 installation.

During MySQL Installation or Upgrade

When installing or upgrading to MySQL 8.0 using the package installer, select Use Legacy Password Encryption in the Configure MySQL Server step.

For more information, see the following webpage:
https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/osx-installation-pkg.html

After MySQL Installation

You can change the default user password authentication plug-in after you have installed MySQL 8.0.

  1. Open System Preferences.
  2. Click MySQL to open MySQL preferences.
  3. On the Instances tab, click Initialize Database.
  4. Select Use Legacy Password Encryption.
  5. When prompted, enter your "root" MySQL password.
  6. Click OK.

Windows

You can change the default user password authentication plug-in during or after MySQL 8.0 installation.

During MySQL Installation or Upgrade

When installing or upgrading to MySQL 8.0 using the package installer, select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility) in the Authentication Method step.

For more information, see the following webpage:
https://dev.mysql.com/doc/mysql-windows-excerpt/8.0/en/mysql-installer-workflow-server.html#server-authentication-method

After MySQL Installation

You can change the default user password authentication plug-in after you have installed MySQL 8.0.

  1. Stop the MySQL server.
  2. Open the my.ini file.
  3. Add the following entry:
    [mysqld]
    default-authentication-plugin=mysql_native_password
  4. Restart the MySQL server.
Like Comment