How to solve the problem when connecting MySQLdb to Django?

Question

MySQL

I need to use MySQL instead of sqlite. I wrote this in settings.py:

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

But when syncing I get the following error:

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

Installed python-mysqldb, but the problem was not solved. What have I done wrong?

Answer 1

Try to install dev dependencies.
Also check if you are executing commands in the virtualenv ( is displayed before the input line)

Answer 2

I encountered the same on arch (python3.3, django 1.6, mariadb 5.5).
The following helped:
using PyMySQL, because Google suggested that mysql-python does not work with python3
Next, in the __init__.py of the application (INSTALLED_APPS), add:

import pymysql
pymysql.install_as_MySQLdb()

Answer 3

Help solve this problem on Windows 10