cPanel & WHM Version 114 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!

Add sql_mode to SQL Configuration

feldon27 shared this idea 7 months ago
Needs Review

In a perfect world, we wouldn't need to allow imperfect MySQL queries, but unfortunately most of us are in the business of supporting dated software.

The new SQL Configuration panel is fantastic and adds all the key settings from /etc/my.conf EXCEPT sql_mode.

This could be presented as either a text field with a link to the MySQL documentation or granular checkboxes. For example:

  • NO_ENGINE_SUBSTITUTION
  • NO_ZERO_DATE

Leave a Comment
 
Attach a file