Author Topic: SQL cfg  (Read 1062 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
SQL cfg
« on: September 19, 2022, 05:09:06 PM »
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.