Get The Most Affordable Hosting in the World!

Starting at just $1.87/month, Vercaa offers unbeatable pricing for world-class web hosting services.

Fast, reliable, and secure hosting to power your website without breaking the bank. Plus, enjoy a free CDN for faster loading times worldwide!

Get Started Now!

You must disable MySQL® Strict Mode in order to run WHMCS on your server. We recommend disabling it at the time of installation to avoid later database errors.

Disabling MySQL Strict Mode requires full root permissions for your server. If you do not have root-level access, contact your hosting provider or system administrator.

Disable MySQL Strict Mode

You can use several different methods to disable MySQL Strict Mode depending on your preferences and the control panel you use.

To disable MySQL Strict Mode:

1. Log in to WHM as the root user and go to Server Configuration >> Terminal.

2. Open the MySQL configuration file using your preferred text editor (for example, nano or vi). For cPanel servers, this is the /etc/my.cnf file:

nano -w /etc/my.cnf
 

3. Edit the sql_mode setting to remove the current value:

sql_mode=
 

4. Restart the MySQL service. To do this in WHM, go to Restart Services >> SQL Server (MySQL).

 

The End! should you have any inquiries, we encourage you to reach out to the Vercaa Support Center without hesitation.

 

Was this answer helpful? 1 Users Found This Useful (1 Votes)