Is it Safe to Disable MySQL Strict Mode ?

piyushmaheswari

Well-Known Member
Apr 18, 2020
74
2
8
India
cPanel Access Level
Root Administrator
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

Well-Known Member
Jun 9, 2020
626
181
43
EU
cPanel Access Level
Root Administrator
I believe so at least from my own experience I always do as it causing more issues with the popular CMS software than good.