id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
28162	"Documented solution to ""MySQL Strict Mode is not set"" warning doesn't work in MySQL 5.5"	Robert Rollins	nobody	"The Django docs claim that you can get rid of this warning by adding the following to your `DATABASES` setting:

{{{
'init_command': ""SET sql_mode='STRICT_TRANS_TABLES'""
}}}

This does not work in MySQL 5.5.47. The warning doesn't go away.

However, adding ''this'' to `DATABASES` does get rid of the warning:

{{{
'OPTIONS': {
    'sql_mode': 'STRICT_TRANS_TABLES',
}
}}}

I found this solution [http://stackoverflow.com/a/23023015/464318 here], but it seems like it really should be in the docs. Unless this doesn't work in newer MySQLs?"	Bug	closed	Documentation	1.10	Normal	worksforme			Unreviewed	0	0	0	0	0	0