'mysql.connector.django' isn't an available database backend Django Version 3.+

Asked Mar 20 '20 at 04:51

Active Jun 29 '21 at 10:29

Viewed 239 times

After Upgrading the version of Django from 2.+ to 3.+ then the error occur after upgrading.

 Django==3.0.4
 mysql-connector==2.2.9
 mysql-connector-python==8.0.19
 mysqlclient==1.4.6
 PyMySQL==0.9.3

====

DATABASES = {
   'default': {
      #'ENGINE': 'django.db.backends.mysql',
      'ENGINE': 'mysql.connector.django',
      'NAME': 'eetech_analytics',
      'USER': 'root',
      'PASSWORD': 'qwerty!123',
      'HOST':'localhost',
      'OPTIONS': {
          'use_pure': True,
          'autocommit': True,
      },
   }
}

and this is the error message:

django.core.exceptions.ImproperlyConfigured: 'mysql.connector.django' isn't an available 
database backend.
Try using 'django.db.backends.XXX', where XXX is one of: 
'mysql', 'oracle', 'postgresql', 'sqlite3'

edited Mar 20 '20 at 06:43

asked Mar 20 '20 at 04:51

larp

1,017
1
14
23

1

Add your database configuration to get more help. From the error message it seems like your configuration has not been done properly. – PyMaster Mar 20 '20 at 05:56
Done, I added the database config. – larp Mar 20 '20 at 06:44
Shouldn't the `ENGINE` be `django.db.backends.mysql` instead? – AKS Mar 20 '20 at 13:50
But in django 2.+ that was the *engine* I used and it is working fine. – larp Mar 23 '20 at 02:55
Does this answer your question? [Django and mysql problems on Mavericks](https://stackoverflow.com/questions/22419210/django-and-mysql-problems-on-mavericks) – Ankit Tiwari Jun 29 '21 at 10:43
also check official doc. https://docs.djangoproject.com/en/3.2/ref/databases/#id8 – Ankit Tiwari Jun 29 '21 at 10:44

'mysql.connector.django' isn't an available database backend Django Version 3.+

0 Answers0