Is it Safe to Disable MySQL Strict Mode ?

piyushmaheswari

• June 18, 2020 09:32

Hello Sir, I want advise from all experts. is it Safe to Disable mysql strict mode ? is it safe to disable mysql strict mode by this method - nano /etc/my.cnf then at the end write this - sql_mode= then save and then restart MySQL server. Actually I want to know that is it safe to disable mysql strict mode, and if yes then is it safe to disable mysql strict mode by the above method I told. In my Server these are running - CloudLinux CPanel LiteSpeed CSF Imunify360 My server is a dedicated server. Please answer my query.

• 

  andrew.n

  • June 18, 2020 19:07

  I believe so at least from my own experience I always do as it causing more issues with the popular CMS software than good.

  0
• 

  cPanelLauren

  • June 18, 2020 23:12

  I think more information on its purpose is also useful and can be found here: MySQL :: MySQL 8.0 Reference Manual :: 5.1.11 Server SQL Modes.

  0

Please sign in to leave a comment.