MySQL Connector/python not working in django

Question

I'm learning Django with MySQL as backend. I installed Oracle's mysql connector to connect with mysql. However, when I run python manage.py I got this error

Traceback (most recent call last): File "C:\Python33\lib\site-packages\django\db\backends\mysql\base.py", line 14, in import MySQLdb as Database ImportError: No module named 'MySQLdb'

That's a bit weird. I was thinking if I installed mysql connector/python I dont need MySQLdb anymore.

Could anyone help explain? Thanks!

My database setting:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': "djangolearn",
    'USER': 'root',
    'PASSWORD': '',
    'HOST': '127.0.0.1',
    'PORT': '3306',
}}

Joe Bobson · Accepted Answer · 2014-09-23 18:58:12Z

4

# for mysql connector use this

DATABASES = {
'default': {
    'ENGINE': 'mysql.connector.django',
    'NAME': 'dbname',               
    'USER': 'user',
    'PASSWORD': '',
    'HOST': '127.0.0.1',
    'PORT': '3306',
},

}

answered Sep 23, 2014 at 18:58

Joe Bobson

1,40617 silver badges21 bronze badges

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

1 Comment

AcckiyGerman Over a year ago

mysql-connector-python, starting from version 8.0.13, has a bug, which makes it impossible to use with Django: code.djangoproject.com/ticket/30469 bugs.mysql.com/bug.php?id=92001 To avoid the bug, add option 'use_pure': True in the database options.

Daniel Roseman · Accepted Answer · 2014-09-23 13:27:43Z

2

If you're using Oracle's connector, you need to use their Django db backend.

See their documentation.

answered Sep 23, 2014 at 13:27

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

1 Comment

JerryDeveloper Over a year ago

Thanks! I also just saw it.

cdvv7788 · Accepted Answer · 2014-09-23 14:55:19Z

1

Try: pip install mysql-python

If that does not work: make sure you can connect to your database (use phpmyadmin or mysql workbench to test that)

answered Sep 23, 2014 at 14:55

cdvv7788

2,0971 gold badge19 silver badges26 bronze badges

Comments

LuciferJack · Accepted Answer · 2017-09-25 05:24:26Z

try this for MySQL Connector that working in django:

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

or try this for MySQL Connector pool that working in django:

DATABASES = {
    'default': {
        'ENGINE': 'PyMysqlPool.mysql.connector.django',
        'NAME': 'djangolearn',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTIONS': {
            'autocommit': True,
            'pool': {
                #use = 0 no pool else use pool
                "use":0,
                # size is >=0,  0 is dynamic pool
                "size":10,
                #pool name
                "name":"local",
            }
        },
    }
}

Collectives™ on Stack Overflow

MySQL Connector/python not working in django

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related