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

How do I import into a MariaDB - MySQL database?

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

How do I update my version of PHP?

PHP needs to be updated. What do I do?We make changing your version of PHP easy. Simply login to...

Warning: system() has been disabled for security reasons

The error message Warning: system() has been disabled for security reasons means that the...

Changing your PHP version

Have you received an error regarding your PHP version? If so, you may quickly and easily change...

How can I find my MariaDB - MySQL version?

Method 1: Through cPanel   Log in to your Ultra Web Hosting account. Click on the cPanel...