The MySQL service must be running on the database server for Jamf Pro to establish a connection during startup. If MySQL is not running when Jamf Pro attempts to connect to the database, a database connection error will appear. Follow these steps to verify and resolve this issue.
Linux
- Log in to the server hosting the MySQL database.
Verify that MySQL is running by executing one of the following commands:
Red Hat Enterprise Linux:service mysqld statusUbuntu:service mysql statusIf the command returns "Active: active (running)", this indicates that MySQL is currently running, and this is not the issue. Refer to the next possible issue to continue troubleshooting.
If the command returns "Active: inactive (dead)", this indicates that MySQL is not currently running. Continue following these steps to resolve.
Execute the following command:
Red Hat Enterprise Linux:service mysqld startUbuntu:service mysql startAfter the service has started, reattempt connection to the database. If the database connection error persists, refer to the next possible issue in this article to continue troubleshooting.
Windows
Log in to the server hosting the MySQL database.
Open Services.
- Locate MySQL in the services list and verify that the service is running.
If Services reports that MySQL is Running, this is not the issue. Refer to the next possible issue in this article to continue troubleshooting.
If Services reports that MySQL is not running, continue following these steps to resolve.
Click Start the service to start MySQL.
Reattempt connection to the database. If the database connection error persists, refer to the next possible issue in this article to continue troubleshooting.