Keep the following in mind before you configure databases for multiple Jamf Pro contexts:
Each Jamf Pro context requires a unique MySQL database and user. You must grant access from each context to its associated MySQL database.
MySQL commands use ALL CAPS as a convention to separate the command syntax from the data provided by the user.
For enhanced security, Jamf strongly recommends unique passwords for each MySQL account. In addition, no additional MySQL passwords should match the MySQL root password. Executing the
select user,host,authentication_stringcommand is a good way to show the MySQL accounts that have been created and the hashed passwords. The hashes should all be unique.If the MySQL service name was changed during installation, that name should be used in all commands calling it, including
startandstop.