SQL Server Variables Resetting after Update

Operating System & Version
CENTOS 7.9 virtuozzo
cPanel & WHM Version
92.0.5

kgs

Member
Dec 15, 2020
11
2
3
USA
cPanel Access Level
Root Administrator
Howdy!

I recently upgraded our VPS's MySQL to 5.7 and had to disable strict mode in order to continue running an old PHP app. This is how I did it:

WHM > phpmyadmin > variables tab > sql mode [edit]

Then I just removed STRICT_TRANS_TABLES from the sql mode settings.

I noticed that those settings had recently reverted to default, I assume because of a CPanel update, but I don't know for sure. So I just removed STRICT_TRANS_TABLES again.

My question is: is there a way to keep these settings from reverting?

Thanks!
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
3,036
380
243
cPanel Access Level
Root Administrator
Hey there! We have an article that explains how to make this change in a way that sticks here:


Can you try that and let me know if that works well for you?