JSS Database Utility: Change MySQL Settings greyed out

Standard

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!

What’s the issue?

The issue is that there is no my.cnf file in /etc/.

What’s the solution?

To resolve;

  1. Quit JSS Database Utility.
  2. 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…”

6. Once selected you’ll be able to change various MySQL settings, with the most common being “Max Packet Size.”

4 thoughts on “JSS Database Utility: Change MySQL Settings greyed out

  1. gskibum

    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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.