Is your MySQL installation dir in the Windows PATH variable? What version of the JSS are you running? What versions of MySQL and Java?

MySQL is installed under C:Program FilesMySQLMySQL Server 5.6. MySQL version 5.6.26, JSS 9.73 and Java SDK 8.51

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.

Hi,

I did the following in my.ini

Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replaced with:

Set the SQL mode to strict

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

yet not change, the option is still greyed out.

Henry,

For me to disable strict mode in the ini file. I just put a # in front of the string to comment it out. I didn't remove anything from the string.

Additional did you copy the my.ini from the ProgramData folder to Program files and restart MySQL?

Thanks @ShaunM9483 this fixed the issue for me.

Thanks for your input , how can I access the greyed out mysql settings on a mac hosted environments

following this nice write up by @bentoms worked for me...

JSS DATABASE UTILITY: CHANGE MYSQL SETTINGS GREYED OUT