Global sql_mode keeps changing

[polle]

I have to run this query every week, the server keeps changing by itself.

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));

I see this when I go to some of that sites and are not working. So noticing this because my sites are down it is not good and of course having the sites down for who knows how many hours or days until I load specific pages, is worse.

What can the problem be?

Thank you.

 

[cPanelLauren]

Hello @polle

To have this last past a restart to MySQL you should add this into /etc/my.cnf, for example:

[mysqld]
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"

 

[polle]

Can you please share exactly what I need to add to /etc/my.cnf to have both things permanent?

Thank you.

 

[lordmwesh]

Open the file /etc/my.cnf

add the line

sql_mode=

save the file

Restart mysql service