Python manage.py migrate error when changing database from sqlite to mysql

Question

I just started learning django. I change the following settings from setting.py because I want to use mysql not sqlite:

DATABASES = {
    'default' : {
        'ENGINE' : 'django.db.backend.mysql',
        'NAME' : 'newprj',
        'USER' : 'root',
        'PASSWORD' : 'abcd',
        'HOST' : 'localhost',
        'PORT' : ''
    }
}

then when I try this code python manage.py migrate on cmd. It throws an big error, I can't understand what is the problem, please help me solve it. This is the error:

i think you should change backend to backends in Engine — Rahil Hastu
– Rahil Hastu, Commented Feb 28, 2019 at 8:55

ans2human · Accepted Answer · 2019-02-28 09:00:08Z

1

You missed the s in django.db.backends.mysql

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',    #<---- You missed the s in backends
        'NAME': 'myproject',
        'USER': 'myprojectuser',
        'PASSWORD': 'password',
        'HOST': 'localhost',
        'PORT': '',
    }
}

answered Feb 28, 2019 at 9:00

ans2human

2,3571 gold badge18 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python manage.py migrate error when changing database from sqlite to mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related