Is it Safe to Disable MySQL Strict Mode ?

P

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

andrew.n

Well-Known Member
Jun 9, 2020
965
358
63
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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
M very large mysqld.log file - safely clear it? Databases 19
F SOLVED MySQL Upgrade Safety Databases 4
A Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/ Databases 3
T mysqld_safe Process Time Warning Databases 1
X Safe to Upgrade to MariaDB 10.1 now? Databases 1
Similar threads
very large mysqld.log file - safely clear it?
SOLVED MySQL Upgrade Safety
Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/
mysqld_safe Process Time Warning
Safe to Upgrade to MariaDB 10.1 now?
Top Bottom