How to Disable Strict mode in Mysql

Freecast · Jun 28, 2018

How to Disable Strict mode in Mysql in Direct Admin ?

smtalk · Jun 28, 2018

You can just set:

Code:

sql_mode=

In /etc/my.cnf.d/server.cnf under [mysqld] section.

AndrewN · Jun 29, 2018

Check /usr/local/mysql/my.cnf for the sql_mode setting and comment it in that file

mbsmt · May 11, 2021

MySQL configuration file in my server was in /etc/my.cnf, so you might need to put sql_mode= in that file.

Richard G · May 11, 2021

I think after 3 years, they know that.

mbsmt · May 11, 2021

I knew. I came back to this post after years, and I saw there is not such path in the comments. So I decided to add it.

Richard G said:
I think after 3 years, they know that.

Richard G · May 12, 2021

mbsmt said:
So I decided to add it.

In fact, the correct answer for these days is already given in post #2.
The /etc/my.cnf is still present but normally the config directory is used.

Which is probably the reason nobody else answered.

prithwirajsinha99 · May 18, 2021

smtalk said:
You can just set:

Code:

sql_mode=

In /etc/my.cnf.d/server.cnf under [mysqld] section.

Richard G · May 18, 2021

The backup may not be complete it says. Please open a seperate topic for your own issues.