Starting with MySQL 8.0, the MySQL database requires an upgraded default user password authentication plug-in to allow access. If this is not configured during installation, the connection will fail. Follow these steps to resolve this issue:
Linux
- Log in to MySQL as the "root" user by executing:
$mysql -u root -h localhost -p - Execute a command similar to the following:
alter user 'jamfsoftware'@'localhost' identified with mysql_native_password by 'jamfsw03';Note:Replace
'jamfsoftware'@'localhost'and'jamfsw03'in the above command with the Jamf Pro database user credentials and location. These should match the credentials and location contained in the DataBase.xml file on the Jamf Pro server. Stop the MySQL server.
Open the my.cnf file.
- Add the following entry:
[mysqld] default-authentication-plugin=mysql_native_password Restart the MySQL server.
Restart the Jamf Pro server.
On the Jamf Pro Server, reattempt the connection to the database.
Windows
- Log in to MySQL as the "root" user by executing:
mysql.exe -h localhost --user=root -p - Execute a command similar to the following:
alter user 'jamfsoftware'@'localhost' identified with mysql_native_password by 'jamfsw03';Note:Replace
'jamfsoftware'@'localhost'and'jamfsw03'in the above command with the Jamf Pro database user credentials and location. These should match the credentials and location contained in the DataBase.xml file on the Jamf Pro server. Stop the MySQL server.
- Open the my.ini file in a text editor other than Notepad.Note:
The my.ini file can be located at C:\ProgramData\MySQL Server 8.x\my.ini.
- Add the following entry:
[mysqld] default-authentication-plugin=mysql_native_password Restart the MySQL server.
Restart the Jamf Pro server.
On the Jamf Pro server, reattempt the connection to the database.