Disable MySQL strict mode on cPanel server

here are the steps on how to disable MySQL strict mode on a cPanel server:

 

  1. Log in to your cPanel server as the root user.
  2. Open the MySQL configuration file, /etc/my.cnf.
  3. Find the sql_mode setting.
  4. Remove the current value of the sql_mode setting.
  5. Save the file.
  6. Restart the MySQL service.

Here are the steps in detail:

  1. Log in to your cPanel server as the root user. You can do this using SSH or the cPanel Terminal.
  2. Open the MySQL configuration file, /etc/my.cnf. You can use a text editor like nano or vi to open this file.
  3. Find the sql_mode setting. This setting is usually located near the bottom of the file.
  4. Remove the current value of the sql_mode setting. The current value of the sql_mode setting may be different depending on your server configuration.
  5. Save the file. You can save the file by pressing Ctrl+S.
  6. Restart the MySQL service. You can restart the MySQL service by running the following command:
/scripts/restartsrv_mysql --force

 

Once you have completed these steps, MySQL strict mode will be disabled on your cPanel server.

 

Additional notes:

  • If you are not sure how to edit the /etc/my.cnf file, you can ask your hosting provider for help.
  • If you are using a newer version of MySQL, you may need to remove the NO_AUTO_CREATE_USER option from the sql_mode setting.
  • After you have disabled MySQL strict mode, you may need to restart your applications or websites.
  • 4 Users Found This Useful

Was this answer helpful?

Related Articles

Internal Server Error with PHPList

PHPList produces internal server error. Checking error logs results in:Invalid command...

How do I import into a MariaDB - MySQL database?

import a database with Ultra Web Hosting phpMyAdmin: Log in to your control panel with...

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

The error message...  The MySQL server is currently offline admin bin Cpanel/cpmysql/DBCACHE:...

PHP information

To view your current version of PHP you will create a php file, for example info.php, and place...

How do I add a user to a MariaDB & MySQL database?

There are two ways to add a user to a MySQL database with Ultra Web Hosting:   Using...