Requirements

When MySQL is installed on a different server than the Jamf Pro web app, MySQL must have proper privileges configured for the Jamf Pro web app to access the database. Certain MySQL queries must be run before you complete the procedure below. For instructions, see the "The database user is not granted proper privileges to the database" section in the Troubleshooting Database Connectivity from the Jamf Pro Server article.

Procedure

After installing the Jamf Pro web app and the MySQL database on different servers, you must do the following:

1. Install the Jamf Pro Server Tools command-line interface (CLI) on the MySQL server. When using the Jamf Pro installer on a single server, the CLI is automatically installed. However, when using two separate servers, you must manually download and install the CLI on the MySQL server. For instructions, see the "Installing the CLI" section of the The Jamf Pro Server Tools Command-Line Interface article.

2. On the Jamf Pro web app server, verify the Jamf Pro web app settings by executing the following command:

   sudo jamf-pro server config list

3. On the MySQL server, verify the database settings by executing the following command:

   sudo jamf-pro database config list

   For more information, see "Step 4: Verify Settings" in the Creating the Jamf Pro Database Using the Jamf Pro Server Tools Command-Line Interface article.

4. Establish the connection between Jamf Pro and MySQL by updating the Jamf Pro server config to point to the MySQL server instead of <localhost> by executing the following command:

   sudo jamf-pro server config set --database-host <FQDN OR IP ADDRESS>