Disable MySQL strict mode on cPanel server

To disable mysql strict mode on a cPanel server, add the following to the end of the /etc/my.cnf file:

 

sql_mode = "NO_ENGINE_SUBSTITUTION

 

and then restart mysql.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

InnoDB: Error: Attempted to open a previously opened tablespace. Previous tablespace

When receiving the error     "InnoDB: Error: Attempted to open a previously opened tablespace....

Clean - Shrink ibdata1

To shrink ibdata1 once and for all you must do the following: MySQLDump all databases into a...

Register Globals On

If you run a script that requires php "register globals on" create a php.ini file and include the...

Error: SoftException in Application(dot)cpp:303 UID of script is small than min_uid

Error: SoftException in Application.cpp:303 UID of script is small than min_uid when going...

Learn MariaDB

MariaDB is a drop-in replacement for MySQL. The lead developer and founder of MySQL, Michael...