How to Turn Off MySQL Strict Mode in WHM

While in WHM navigate to SQL Services then phpMyAdmin. phpMyAdmin will probably open in a new window. Look at the top and towards the right for variables. Click on that then either scroll down to sql mode or use the filter. Hover over the row that says sql mode and an edit button should appear. STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION Change to: NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION If an edit button does not appear you may not have permission to edit the value. If you have root access try logging in [...]