Django backend wont connect to mysql database

Django
1

error: django.core.exceptions.ImproperlyConfigured: 'django.db.backends.mysql

I can use mysql in vscode terminal and mysqlclient installs no issues. But when trying to enter mysql in database settings in settings.py says:

‘django.db.backends.mysql’ isn’t an available database backend or couldn’t be imported. Check the above exception. To use one of the built-in backends, use ‘django.db.backends.XXX’, where XXX is one of:
‘oracle’, ‘postgresql’, ‘sqlite3’

My code:

DATABASES = {
‘default’: {
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘storefront’,
‘HOST’: ‘localhost’,
‘USER’: ‘root’,
‘PASSWORD’: ‘mypassword’
}
}

Thanks in advance. Really stuck, cant find liegit answer online. Tried deactivating virtual env and reinstalling requirements but did not work.

2

I have found someone with same problem but no solution on stackflow

3

try to make your “storefront” database as a default database in datagrip or whichever db managing app you are using

5

Hi emmav,

Which server version of MySQL do you have installed?

You can find that by starting MySQL Command Line Client on your computer.
It will prompt you for your root-password. Please enter that and write \s in the terminal in order to see your server version.

7

Hey Emmav, i had the same issue with postgresql and i had to do was to upgrade the django version and migrated smooth.