keat63

Well-Known Member
Nov 20, 2014
1,899
253
113
cPanel Access Level
Root Administrator
I think it's about time that I took the plunge and updated MYSQL to 5.7.
However, I understand that strict mode may need to be disabled.

I've done some searching but there are so many different methods, comments or threads, i'm losing the plot.
For fear of making a massive blunder, could anyone please offer me a definitive example on how to disable strict mode.
 
  • Like
Reactions: cPanelLauren

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,743
306
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
Putting this in your my.cnf would do it

sql_mode=NO_ENGINE_SUBSTITUTION

But you are correct, there are a number of different ways, but most involve that line.
 

keat63

Well-Known Member
Nov 20, 2014
1,899
253
113
cPanel Access Level
Root Administrator
I've seen various threads also pointing to the location of my.cnf, with differing opinions.
Mine currently resides in /etc, and only contains 9 lines.
Is this correct ?

I assume, the file will reside in the same location after the update ?
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,257
313
Houston
Hi @keat63

I've seen various threads also pointing to the location of my.cnf, with differing opinions.
Mine currently resides in /etc, and only contains 9 lines.
Is this correct ?

I assume, the file will reside in the same location after the update ?
While you could have per user .my.cnf files in other locations the primary config file will always (or should always) be in /etc/