Skip to main content
Question

Re-Setting Up Test Local JSS SQL Syntax Issue

  • July 19, 2018
  • 1 reply
  • 0 views

Forum|alt.badge.img+2

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
mysql>

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.

1 reply

sdagley
Forum|alt.badge.img+25
  • Jamf Heroes
  • 3540 replies
  • July 19, 2018

@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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings