disable strict mode

keat63

• February 26, 2019 09:05

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

  • February 26, 2019 15:53

  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.

  0
• 

  cPanelLauren

  • February 26, 2019 20:55

  The suggestion provided by @GOT is the most commonly used

  0
• 

  keat63

  • February 27, 2019 07:38

  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 ?

  0
• 

  cPanelLauren

  • February 27, 2019 13:52

  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/

  0

Please sign in to leave a comment.