How to disable MySQ...
 
Notifications
Clear all

How to disable MySQL strict mode?

0 Posts
1 Users
0 Likes
3 Views
0
Topic starter

Disabling MySQL strict mode is an important operation in WHMCS. In this Blog we will learn how to properly edit MySQL Configuration on a cPanel server to ensure that a consumer using the proper SQL Mode.

Important Note:To make the following changes, the server you are on will need full root permission If you do not have full root permission, you will need to contact your web host or system administrator to request it.

Using your favorite SSH client or through WHM's built-in terminal function. In this case, we will use the terminal function found in WHM v72+. If you are using an older version of WHM/cPanel, the steps are the same through your SSH client.

To get started, go to the Terminal option found under the Server Settings heading in WHM.

Once in the terminal session, open the MySQL configuration file 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.

Share:

HIRE PROFESSIONALS TO AMPLIFY YOUR BUSINESS GROWTH

professional team
tick mark Over 10 years of experience in managing all size of tech projects.
tick mark Experienced with WHMCS, WordPress and Linux Setup and Customization.
tick mark We are committed to provide you the best price, products, and services.
tick mark All under one roof: Our Honesty, Professionalism and Quality unlike others!
tick mark All the team members have one thing in common: we are all tech NERD!!