Creating the Jamf Pro Database and MySQL User Account

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US
  1. Execute the following command from a terminal or command prompt:
    sudo jamf-pro database init
    Note:

    If you choose not to use sudo, the Jamf Pro Server Tools CLI may not be able to save the Jamf Pro-to-MySQL configuration information.

  2. When prompted, enter your MySQL root user password.
    Note:

    An option will appear to set the MySQL root user password. If you had previously used a temporary root password, you can set a new MySQL root password now. Press Enter to skip this option.

  3. Enter the name that you want to use for the Jamf Pro database (for example, "jamfpro").
  4. Enter the username of a MySQL account for Jamf Pro to use to access the database (for example, "jamfpro"). If you enter a new username, it will be created.
  5. Enter a new, strong user password for the MySQL account.
    Note:

    If you forget to enter the password, you can repeat the steps above. When you enter the old username, the password will be reset.

  6. A database connection test will run. You should see a message similar to the following:
    Testing database connection... connected to 'jamfpro' as 'jamfpro'
  7. When prompted, press "Y" if you want to save the database connection settings to the Jamf Pro configuration file (DataBase.xml).
  8. When prompted, press "Y" if you want to save the username and password to the Jamf Pro Server Tools CLI configuration file so the CLI can connect to the database in the future.