Thursday, November 12, 2015

Disable MySQL Strict mode in Debian 8 permanently

All blogs say:

 for turning off strict mode you must add following line to /etc/mysql/my.cnf:


and restart the mysql server.

That was not working me.

I have found another setting file for mysql: /usr/my.cnf

and in this file exists sql_mode parameter too.


this line must be commented out too:


Don't forget to restart the mysql server.

No comments: