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

How to Disable XCache for a Domain

On many of our servers xcache is use as part of the php caching mechanism. If you are...

Premature end of script headers

If you receive an Internal Server Error 500 and checking your log files displays "Premature end...

I am having problems with a script I wrote

PHP suexec is running on all of our shared servers. If you are running code that is insecure or...

How can I view/modify data in my MariaDB - MySQL database?

Only make changes if you know exactly what you are doing. Often incorrect changes can have an...

Learn MySQL

If you do not know how to use MySQL there are some great guides at the following websites....