This article explains how to create the Jamf Pro database using the Jamf Pro Server Tools command-line interface (CLI). The Jamf Pro web application stores its data in the Jamf Pro database and requires credentials for a user that has full access to that database.
The Jamf Pro Server Tools CLI can still be used when Jamf Pro and MySQL are installed on different servers. However, it may be necessary to install the CLI on all servers. The appropriate settings will need to be set with the CLI on each server.
It is recommended that Jamf Pro be installed before the Jamf Pro database is created. The advantage is that the Jamf Pro Server Tools CLI is installed with the Jamf Pro installer. The CLI simplifies the process of creating the database as opposed to creating the database manually. In addition, while the Jamf Pro database can be created and configured before Jamf Pro is installed, the Jamf Pro-to-MySQL connection information cannot be configured until after Jamf Pro is installed.
Creating the Jamf Pro database and configuring the connection information involves the following steps:
Verifying the Jamf Pro Server Tools CLI Version
Creating the Jamf Pro Database and MySQL User Account
Configuring MySQL
Verifying Settings
Restarting the Services
Accessing Jamf Pro
Red Hat Enterprise Linux:
sudo jamf-pro ... commands provided below return a "command not found" error, make sure the CLI is accessible from the root path by executing the following command:sudo ln -s /usr/local/bin/jamf-pro /bin/jamf-pro