How to find and disable MySQL strict mode?

mysql cpanel whmcs strict-mode
Hamed Atae picture Hamed Atae · Jun 22, 2016 · Viewed 47.7k times · Source

Hello everybody I wanted to find this mysql strict mode for whmcs and disable it but i didn't had a progress I'm a newbie so sry if I didn't mention other things Can anyone help me? I'm working on WHM/Cpanel

Answer

Coz picture Coz · Mar 11, 2017

To turn off (or on) mysql strict access from cpanel.

1, search for 'phpmyadmin', in the search box, click on it

2, once phpmyadmin is loaded up, click on the 'variables' tab

3, search for 'sql mode'

then

to turn strict mode on enter

STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

to turn strict mode off, enter

NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

If you have control of the script you'll be using then it's a good idea to leave strict mode on, it'll alert you to any bugs in your code before they become an issue down the line.

Related questions

#1273 - Unknown collation: 'utf8mb4_unicode_ci' cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the environment, I keep getting this error: #1273 - Unknown collation: 'utf8…

Read More
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Hello, I am currently having an issue with MySQL! What's going wrong here? I am a cPanel user, and yes I have searched this and found no definitive answers. It appears this is more specific than other people with the …

Read More
Mysql cannot connect - Access denied (using password yes)

I have hosting provided by eleven 2 and I just created a new MySQL user and gave it access to every action listed. I'm getting the following error Warning: mysql_connect() [function.mysql-connect]: Access denied for user '(username is here, …

Read More