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

Error 500 - Internal Server Error - PHP

This can be due to several factors. The first thing to check is that the permissions on the file...

What is the Path to ImageMagick?

The path to ImageMagick on Ultra Web Hosting is /usr/bin/. This means that you can access...

HTTP Authentication error in PHP

A HTTP Authentication error in PHP occurs when the user is not authorized to access the requested...

How do I change my PHP settings?

How do I change my PHP / PHP.INI settings?To change your PHP settings, just login to your hosting...

Changing Maximum Upload Size

Firts check your control panel for the "MultiPHP INI Editor" icon. If available you can change...