I'm working on whmcs and it requires disabling MYSQL strict mode.
我正在研究whmcs,它需要禁用MYSQL严格模式。
I searched about it and it says you can find it in my.ini or my.cnf.
我搜索了它,它说你可以在my.ini或my.cnf中找到它。
My problem is that I can't find it in any place in file manager. Can Someone help me find and edit it?
我的问题是我无法在文件管理器的任何地方找到它。有人可以帮我查找和编辑吗?
2 个解决方案
#1
2
You will not find my.cnf file in your File Manager. Generally it resides in /etc directory. If you are on shared server, you will not have access of this file.
您将无法在文件管理器中找到my.cnf文件。通常它驻留在/ etc目录中。如果您在共享服务器上,则无法访问此文件。
If you have VPS/Dedi. Server, you can SSH into the server and edit this file. Use any editor like vi, nano to edit this file.
如果你有VPS / Dedi。服务器,您可以SSH到服务器并编辑此文件。使用任何编辑器(如vi,nano)编辑此文件。
You will have to set blank in sql-mode i.e.
你必须在sql模式中设置空白,即
sql_mode=""
Then restart MySQL service.
然后重启MySQL服务。
#2
-1
I think you are on Shared hosting. You are not allowed to do this (edit my.cnf etc) in shared hosting. If you are using VPS/Dedicated Server, then you can edit /etc/my.cnf via SSH Client and a editor like vi. To edit this file on browser, install "config server explorer" cpanel plugin via SSH on your server. http://configserver.com/cp/cse.html then you can edit system files via WHM.
我想你是在共享主机上。您不能在共享主机中执行此操作(编辑my.cnf等)。如果您使用的是VPS / Dedicated Server,则可以通过SSH客户端和vi等编辑器编辑/etc/my.cnf。要在浏览器上编辑此文件,请在服务器上通过SSH安装“config server explorer”cpanel插件。 http://configserver.com/cp/cse.html然后您可以通过WHM编辑系统文件。
#1
2
You will not find my.cnf file in your File Manager. Generally it resides in /etc directory. If you are on shared server, you will not have access of this file.
您将无法在文件管理器中找到my.cnf文件。通常它驻留在/ etc目录中。如果您在共享服务器上,则无法访问此文件。
If you have VPS/Dedi. Server, you can SSH into the server and edit this file. Use any editor like vi, nano to edit this file.
如果你有VPS / Dedi。服务器,您可以SSH到服务器并编辑此文件。使用任何编辑器(如vi,nano)编辑此文件。
You will have to set blank in sql-mode i.e.
你必须在sql模式中设置空白,即
sql_mode=""
Then restart MySQL service.
然后重启MySQL服务。
#2
-1
I think you are on Shared hosting. You are not allowed to do this (edit my.cnf etc) in shared hosting. If you are using VPS/Dedicated Server, then you can edit /etc/my.cnf via SSH Client and a editor like vi. To edit this file on browser, install "config server explorer" cpanel plugin via SSH on your server. http://configserver.com/cp/cse.html then you can edit system files via WHM.
我想你是在共享主机上。您不能在共享主机中执行此操作(编辑my.cnf等)。如果您使用的是VPS / Dedicated Server,则可以通过SSH客户端和vi等编辑器编辑/etc/my.cnf。要在浏览器上编辑此文件,请在服务器上通过SSH安装“config server explorer”cpanel插件。 http://configserver.com/cp/cse.html然后您可以通过WHM编辑系统文件。