如何查找和禁用MySQL严格模式?

问题描述:

大家好,我想为whmcs找到这个mysql严格模式并将其禁用,但是我没有任何进展 我是新手,如果我不提其他事情,我很抱歉 谁能帮我? 我正在研究WHM/Cpanel

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

要从cpanel关闭(或打开)mysql严格访问权限.

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

1,搜索"phpmyadmin",在搜索框中单击它

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

2,加载phpmyadmin后,单击变量"标签

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

3,搜索"sql模式"

3, search for 'sql mode'

然后

打开严格模式进入

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.