When creating test JSS instances, I often stumble over this issue where the “Change MySQL Settings…” option is greyed out
What’s the issue?
The issue is that there is no my.cnf file in /etc/.
What’s the solution?
To resolve;
- Quit JSS Database Utility.
- Run the following commands in Terminal:
sudo cp -r /usr/local/mysql/support-files/my-huge.cnf /private/etc/my.cnf
sudo chown root /etc/my.cnf
3. Restart MySQL.
4. Open JSS Database Utility
5. Click “Utilities” in the menubar & you should now be able to select “Change MySQL Settings…”
![](https://i0.wp.com/macmule.com/wp-content/uploads/2021/11/mysql-not-greyed-out.png?resize=445%2C130&ssl=1)
6. Once selected you’ll be able to change various MySQL settings, with the most common being “Max Packet Size.”
![](https://i0.wp.com/macmule.com/wp-content/uploads/2021/11/Screen-Shot-2013-12-13-at-10.13.15-PM.png?resize=696%2C503&ssl=1)
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!