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.

mysql 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;

  1. Quit JSS Database Utility.
  2. Run the following commands in Terminal:
  3. Restart MySQL.
  4. Open JSS Database Utility
  5. Click “Utilities” in the menubar & you should now be able to select “Change MySQL Settings…”

mysql not greyed out

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

Screen Shot 2013-12-13 at 10.13.15 PM

 

 

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.