{"id":10911,"date":"2025-01-17T06:52:24","date_gmt":"2025-01-17T06:52:24","guid":{"rendered":"https:\/\/www.trustedhosting.in\/blog\/?p=10911"},"modified":"2025-01-17T06:52:24","modified_gmt":"2025-01-17T06:52:24","slug":"how-to-disable-mysql-strict-mode","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/how-to-disable-mysql-strict-mode\/","title":{"rendered":"How to Disable MySQL Strict Mode"},"content":{"rendered":"

\"How<\/a><\/h1>\n

How to Disable MySQL Strict Mode<\/h1>\n
\n
\n

You\u00a0must<\/strong>\u00a0disable MySQL\u00ae Strict Mode in order to run WHMCS on your server. We recommend disabling it at the time of installation to avoid later database errors.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n
\n

Disabling MySQL Strict Mode requires full\u00a0root<\/code>\u00a0permissions for your server. If you do not have\u00a0root<\/code>-level access, contact your hosting<\/a> provider or system administrator.<\/p>\n<\/div>\n<\/div>\n

\n

Disable MySQL Strict Mode<\/h2>\n
\n
\n

You can use several different methods to disable MySQL Strict Mode depending on your preferences and the control panel you use.<\/p>\n<\/div>\n<\/div>\n

\n
\n

The example below illustrates disabling MySQL Strict Mode on a cPanel server using the\u00a0Terminal<\/strong>\u00a0feature. You can also use these steps using an SSH client.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n
\n

To disable MySQL Strict Mode:<\/p>\n

1. Log in to WHM as the root user and go to\u00a0Server Configuration >> Terminal<\/strong>.<\/p>\n

2. Open the MySQL configuration file using your preferred text editor (for example,\u00a0nano<\/code>\u00a0or\u00a0vi<\/code>). For cPanel servers, this is the\u00a0\/etc\/my.cnf<\/code>\u00a0file:<\/p>\n

\n
nano -w \/etc\/my.cnf<\/code><\/pre>\n
3. Edit the sql_mode<\/code>\u00a0setting to remove the current value:<\/div>\n<\/div>\n
\n
sql_mode=<\/code><\/pre>\n
4. Restart the MySQL service. To do this in WHM, go to Restart Services >> SQL Server (MySQL)<\/strong>.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
How to Disable MySQL Strict Mode You\u00a0must\u00a0disable MySQL\u00ae Strict Mode in order to run WHMCS on your server. We recommend…<\/p>\n","protected":false},"author":1,"featured_media":10913,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whmcs"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/10911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=10911"}],"version-history":[{"count":2,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/10911\/revisions"}],"predecessor-version":[{"id":10914,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/10911\/revisions\/10914"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/10913"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=10911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=10911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=10911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}