Django sql connection failed

Question

I have created new project in django and write mysql connection in it's settings file like :

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'optdb',
        'User': 'root',
        'Password':'975',
        'Host':'127.0.0.1',
        'Port':'8080',
    }
}

Now i write command : python manage.py syncdb and that generates following error:

enter image description here How to solve this error mentioned above? Note: I have currently one user in my MYSQL WAMP SERVER that is root with host 127.0.0.1.

hcarver · Accepted Answer · 2014-03-22 09:55:35Z

1

All of those keys should be in capitals.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'optdb',
        'USER': 'root',
        'PASSWORD':'975',
        'HOST':'127.0.0.1',
        'PORT':'8080',
    }
}

answered Mar 22, 2014 at 9:55

hcarver

7,3445 gold badges44 silver badges67 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:05:21Z

1

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'optdb',
        'USER': 'root',
        'PASSWORD':'975',
        'HOST':'127.0.0.1',
        'PORT':'8080',
    }
}

It's case sensitive...

Also, are you sure your mysql server is at port 8080? That's unusual. If unsure, just leave out that line and default mysql port will be used. See How can I connect to MySQL on a WAMP server?

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Mar 22, 2014 at 9:56

frnhr

13k9 gold badges70 silver badges96 bronze badges

Collectives™ on Stack Overflow

Django sql connection failed

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related