Bobcares

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL EXTENSION

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL EXTENSION

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

cPanel Disable MySQL Strict Mode | How To?

by | Oct 5, 2023

How to disable MySQL Strict Mode on the cPanel server? Read the article to find out. At Bobcares, with our MySQL Support Service, we can handle your MySQL issues.

Steps to Disable MySQL Strict Mode on the cPanel Server

We can run the following steps in order to disable MySQL Strict Mode on the Server:

1. Log in as the root user to the cPanel server. We can use both SSH and the cPanel Terminal for this.

2. Open the /etc/my.cnf setup file for MySQL. In order to open this file, use a text editor.

3. Locate the sql_mode setting. This parameter is typically found near the file’s bottom.

4. Remove the sql_mode setting’s current value. Depending on the server setup, the sql_mode setting’s current value can be different.

5. Now, save the file. The file can be saved by pressing Ctrl+S.

6. Launch the MySQL service once more. Use the command line interface to restart the MySQL service:

cpanel disable mysql strict mode

After we finish those steps, the cPanel server will no longer use MySQL strict mode. We may need to restart the programs or webpages after disabling MySQL’s strict mode.

[Need to know more? We’re available 24/7.]

Conclusion

To sum up, this article offers the steps from our Tech team to disable MySQL Strict Mode on the cPanel server.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.