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

Useful CSV to MySQL Script

The link below is a great tool we have run into for converting CSV files into MySQL format:CSV to...

How can I parse html as php?

Create an .htaccess file and upload it to the root of your public_html directory. Include the...

PHP information

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

Warning: Unknown(): open_basedir restriction in effect

Basedir restriction is set for security. This most often occurs when you are calling an app...

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

There are two ways to view your MySQL database with Ultra Web Hosting: Using phpMyAdmin Go...