How To Disable MySQL Strict Mode

It is important that MySQL Strict Mode is disabled for the proper operation of Sendroid Ultimate. In this example we will detail how to properly edit the MySQL Configuration on a cPanel server to ensure we are using the proper SQL Mode.

Note: In order to make the following changes, you will need full root permissions for the server you are on. If you do not have full root permissions, you will need to contact your web host or sysadmin to request this be done.

Using your favorite SSH Client or via the built in Terminal feature of WHM. In this case we will be using the Terminal Feature found within WHM v72+. If you are using an older version of WHM/cPanel, the steps are the same via your SSH client.

To get started, simply navigate to the Terminal option found under the Server Configuration heading in WHM.

Once in the terminal session, open the MySQL configuration file up with your favorite text editor (nano, vi, etc.). For cPanel servers, the location of the MySQL Configuration file is /etc/my.cnf and we will edit it by doing the following:

Edit the sql_mode value within this file and remove any value it has. The result should be as follows:

Restart the MySQL service. Since we are already logged into WHM, simply choose to restart the MySQL service from the left-hand column:

 

 
  • mysql strict mode, sendroid ultimate
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How To Change cPanel Default Time Zone

The .htaccess file is a hidden text file within your hosting account that can be very powerful....

How To Restore a Home Directory Backup in cPanel

In this article I'm going to show you how to restore a partial home directory backup in cPanel....

How to Create a MySQL Database in cPanel

When you create a database, many users are unaware that there are several other items that you...

Install SSL certificates with cPanel SSL/TLS Manager

Enable SSL/TLS Manager in WHM for cPanel users Before using the SSL/TLS Manager as a cPanel...

5 Important Things to Consider When Choosing a Domain for Your Business or Website

When first setting up any website, one of the hardest — but most important — things to decide is...