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

The MySQL server is currently offline. admin bin Cpanel/cpmysql/DBCACHE: exit 11

# This error shows in all user control panels via the "MySQL Databases" icon...   The MySQL...

How do I backup a MariaDB - MySQL Database?

In the control panel, within Backup section, under Download a SQL Database Backup will be your...

Learn MySQL

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

403 Forbidden error with Drupal after install.

Remove the following lines from the .htaccess file... Options -Indexes Options FollowSymLinks...

Error: SoftException in Application.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...