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/.
- 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.”