# (mysql.W002) MySQL Strict Mode is not set for database connection 'default'

**URL:** <https://forum.codewithmosh.com/t/mysql-w002-mysql-strict-mode-is-not-set-for-database-connection-default/5884>\
**Category:** Python\
**Created:** [July 4, 2021, 12:17pm UTC](https://forum.codewithmosh.com/t/mysql-w002-mysql-strict-mode-is-not-set-for-database-connection-default/5884 "2021-07-04T12:17:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![namalspencer](https://avatars.discourse-cdn.com/v4/letter/n/c4cdca/32.png) [@namalspencer](https://forum.codewithmosh.com/u/namalspencer)\
**Post date:** [July 4, 2021, 12:17pm UTC](https://forum.codewithmosh.com/t/mysql-w002-mysql-strict-mode-is-not-set-for-database-connection-default/5884/1 "2021-07-04T12:17:14Z")

</div>

Hello Sir

I go through this link bellow  
[https://docs.djangoproject.com/en/3.2/ref/databases/#mysql-sql-mode](https://docs.djangoproject.com/en/3.2/ref/databases/#mysql-sql-mode)

and I change the settings.py in DATABASES

DATABASES = {

```
'default': {

    'ENGINE': 'django.db.backends.mysql',

    'NAME': 'storefront',

    'OPTIONS': {

        'init_command': 'SET default_storage_engine=INNODB',

    },

    'HOST': 'localhost',

    'USER': 'root',

    'PASSWORD': '',

}

```

}

But still popup following warning

WARNINGS:  
?: (mysql.W002) MySQL Strict Mode is not set for database connection ‘default’  
HINT: MySQL’s Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: [Databases | Django documentation | Django](https://docs.djangoproject.com/en/3.2/ref/databases/#mysql-sql-mode)

Please help