Configuring MySQL 8.0 for Jamf Pro

Updated: 15 February 2022
Product: Jamf Pro

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 instructions on upgrading to MySQL 8.0, see the following article: Upgrading to MySQL 8.0.

Note:

Hosting Jamf Pro databases with MySQL 8.0 on Amazon RDS is not currently supported.

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:

Setting the default authentication plug-in to mysql_native_password or Legacy Password Encryption method

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.

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.

macOS

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/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password

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.