Manually Creating the Jamf Pro Database

This article explains how to manually create the Jamf Pro database. The Jamf Pro web application requires the Jamf Pro database for storing its data and credentials for a user that has full access to that database.

MySQL is the database subsystem used by Jamf Pro. MySQL can be a local instance, residing on the same server as Jamf Pro, or MySQL can reside on a different server. While there are various methods for connecting to MySQL to perform the following tasks, the process described here is for connecting locally to the mysql command line on the same server on which MySQL is installed.

Creating the Jamf Pro database involves the following steps:

1. Configuring MySQL 8.0 for Jamf Pro

2. Connecting to MySQL

3. Understanding MySQL Passwords

4. Creating the Jamf Pro Database

5. Creating the Jamf Pro Database User

6. Granting Access to the Database

7. Exiting MySQL

8. Configuring MySQL

9. Restarting MySQL

10. Stopping Tomcat

11. Configuring the Connection Between Jamf Pro and the Database

12. Starting Tomcat and Accessing Jamf Pro (new Jamf Pro installations only)