disable strict mode

[keat63]

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.

 

[GOT]

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.

 

[cPanelLauren]

The suggestion provided by @GOT is the most commonly used

 

[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 ?

 

[cPanelLauren]

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/