Disable Strict mode in Mysql

jonium

Verified User
Joined
Nov 10, 2010
Messages
122
Location
Alezio - Lecce- Apulia - South Italy
Hello,
I need to disable Strict mode in Mysql, I tried to do it putting NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION as Sql_mode but at the restart of mysql it is set again so:
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER

After every mysql restart I need to access mysql from command line and do:
SET @@sql_mode = '';
SET @@GLOBAL.sql_mode = '';

Is there a way to definitively set them?
 
Last edited:

jinfo

New member
Joined
Oct 3, 2008
Messages
3
Check /usr/local/mysql/my.conf for the sql_mode setting and comment it in that file as well. Should be all good then!
 
Top