New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

SQL cfg

Started by james88, September 19, 2022, 05:09:06 PM

Previous topic - Next topic

james88

if i copy cfg from /etc/my.cnf.d/server.cnf to /etc/my.cnf will it binde and run off that cfg ?

only way got it to work is using phpadmin Run SQL query/queries on server
SET GLOBAL sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"




1) Open the  /etc/my.cnf   file by accessing your server via SSH or SFTP with root authority.
(If you do not have root access, these process must be provided by people who are authorized to access the server root.)


2) Add the sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" definition to the bottom of the file "my.cnf" and save it.

If your server does not accept ", you can define without ". If this doesn't work, you can just define it as sql_mode=
The definition you add should be under the [mysqld] line. If your file does not contain the line [mysqld], you can add it manually.