我可以在浏览器中编辑my.ini或my.cnf文件吗?

时间:2022-06-18 14:22:34

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编辑系统文件。