Re-Setting Up Test Local JSS SQL Syntax Issue

New Contributor

Hello All,

I recently reformatted my test machine and usually when setting up a local JSS use the instructions provided in the jam documentation. However I am now getting the following error when using the MYSQL command I always use to grant privileges

mysql> GRANT ALL ON jamfsoftware.* TO 'jamfsoftware'@localhost IDENTIFIED BY 'jamfsw03';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'jamfsw03'' at line 1

Has there been a syntax change in MYSQL Community Server version 8.0.11 and if so what should I use for the above command instead?

Any help sincerely appreciated, thanks in advance.


Honored Contributor III

@AndrewFromIT The Jamf Pro 10.5 System Requirements call for MySQL 5.6 as minimum required, and MySQL 5.7 as recommended. You probably don't want to be running MySQL 8.