Changing the Jamf Pro MySQL Account Password

Technical Articles

Solution

Application

Content Type

Technical Documentation

Utilities & Services

ft:locale

en-US

Confirm the username for the MySQL account being used by Jamf Pro by doing one of the following:
- Execute the following command using the Jamf Pro Server Tools CLI:
```
jamf-pro config list
```
- Open the Database.xml file at one of the paths listed in the next step to verify the username that is in use.
Connect to the MySQL prompt using the MySQL root user credentials by executing the following command:
```
mysql -u root -p
```
When prompted, enter the root user password.
At the mysql> prompt, change the password for the account that is used by Jamf Pro by executing a command similar to the following:
```
ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password';
```
Substitute your information for username and new_password above.
For MySQL 5.7, you may need to execute a command similar to the following:
```
SET PASSWORD FOR 'username'@'localhost' = PASSWORD('new_password');
```
Verify the password was changed by doing the following:
1. Type exit to exit the MySQL prompt you are connected to with the root user.
2. Connect to the MySQL prompt with the Jamf Pro MySQL account credentials by executing a command similar to the following:
```
mysql -u username -p
```
  Substitute your information for username above.
3. When prompted, enter your new password.
4. Type exit to exit the MySQL command prompt.