Breaking News: Grepper is joining You.com. Read the official announcement!

How to fix: MariaDB Strict Mode is not set for database connection 'default'

Coding Gear answered on September 4, 2022 Popularity 4/10 Helpfulness 8/10

answer How to fix: MariaDB Strict Mode is not set for database connection 'default'

How to fix: MariaDB Strict Mode is not set for database connection 'default'

Comment

#The warning
WARNINGS:
?: (mysql.W002) MariaDB Strict Mode is not set for database connection 'default'
        HINT: MariaDB's Strict Mode fixes many data integrity problems in MariaDB, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/4.1/ref/databases/#mysql-sql-mode
        
#The solution
# add OPTIONS to DATABASES in settings.py 

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'database_name',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTIONS': {'init_command': "SET sql_mode='STRICT_TRANS_TABLES'"}, # add this line
    }
}

# run the migrations
(env) $ python manage.py migrate

Popularity 4/10 Helpfulness 8/10 Language python

Source: codinggear.blog

Tags: database-connection mariadb python set strict-mode

Link to this answer
Share Copy Link

Contributed on Sep 04 2022

Coding Gear

0 Answers Avg Quality 2/10

How to fix: MariaDB Strict Mode is not set for database connection 'default'

Contents

More Related Answers

How to fix: MariaDB Strict Mode is not set for database connection 'default'

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.