Using MySQL in Django

After you have done everything and installed mysql and mysql client. You have to create a db with datagrip. It is this database that we will connect to django with.

Now instead of the default sqlite that comes with django, we want to use mysql instead. So navigate into your project’s settings file and set the database engine to mysql. The reason why we installed mysqlclient is because of this. See below

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'storefront',
        'HOST': 'localhost',
        'USER': 'root',
        'PASSWORD': 'your-password-here'
    }
}

Re run your server and if you get no errors, you are good to go. Now you can run your migrations, and you will see that when you go to datagrip, the database tables will be there.