Django backend wont connect to mysql database

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 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:

‘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.

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

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

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.

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