When creating test JSS instances, I often stumble over this issue where the “Change MySQL Settings…” option is greyed out.
This often leads to me having to contact JAMF Support for a refresher. Well hopefully this post will remind me!
The issue is that there is no my.cnf file in /etc/.
To resolve;
- Quit JSS Database Utility.
- Run the following commands in Terminal:
- Restart MySQL.
- Open JSS Database Utility
- Click “Utilities” in the menubar & you should now be able to select “Change MySQL Settings…”
Once selected you’ll be able to change various MySQL settings, with the most common being “Max Packet Size.”
Do you have a fix for this for Windows?
I ran into this after upgrading MySQL from 5.6 to 5.7 by uninstalling 5.6 and installing 5.7.
However there were no such files in /usr/local/mysql/support-files.
So I just took the my.cnf backup file I had saved and copied it to /etc and this problem was solved.
Thanks for the updates!