Configuring MySQL 8.0 for 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.
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 toOFF
to prevent extra disk space from being used.
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
Stop the MySQL server.
Open the my.cnf file.
Add the following entry:
[mysqld] default-authentication-plugin=mysql_native_password
Restart the MySQL server.
Windows
- 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:
- After MySQL Installation
You can change the default user password authentication plug-in after you have installed MySQL 8.0.
Stop the MySQL server.
Open the my.ini file.
- Add the following entry:
[mysqld] default-authentication-plugin=mysql_native_password
Restart the MySQL server.
macOS
- 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:
- After MySQL Installation
You can change the default user password authentication plug-in after you have installed MySQL 8.0.
Open System Preferences.
Click MySQL to open MySQL preferences.
On the Instances tab, click Initialize Database.
Select Use Legacy Password Encryption.
When prompted, enter your "root" MySQL password.
Click OK.