Global sql_mode keeps changing

polle

• March 30, 2019 01:56

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

  • April 01, 2019 21:04

  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"
  

  0
• 

  polle

  • April 08, 2019 04:22

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

  0
• 

  lordmwesh

  • December 06, 2019 13:02

  Open the file /etc/my.cnf add the line sql_mode=
  save the file Restart mysql service

  0

Please sign in to leave a comment.