Im running JSS on a Windows platform and within the JSS Database Utility the Change MySQL Settings greyed out under the utilities drop down menu. I researched and have seen a solution for mac hosted environments but was unable to find one for Windows. Has anyone been able to resolve this or is this a matter of the Utility version and MySQL version being a mismatch.
Solved! Go to Solution.
I've had this issue a while ago. As I recall from my experience.... With MySQL 5.6 best practice is to make sure StrictTables are disabled. Which should be in your my.ini file. I believe it is located by default in c:ProgramDataMySQLMySQL Server 5.6.
After editing your my.ini I copied it to the MYSQL directory in program files, confirm the MySQL variable in Windows path environmental variable and restarted MySQL and that fixed the issue for me.
Granted this was a while ago but I am 95% sure that is how we resolved the issue.