Hamed Atae Hamed Atae - 5 months ago 27
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?

Answer

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.

sql_mode=""

Then restart MySQL service.