Hamed Atae Hamed Atae - 1 year ago 59
SQL Question

Can I edit my.ini or my.cnf file in browser?

I'm working on whmcs and it requires disabling MYSQL strict mode.

I searched about it and it says you can find it in my.ini or 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?


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.

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.

You will have to set blank in sql-mode i.e.


Then restart MySQL service.