[Django] Setup connection with MySQL

Rex Chiang

·

Follow

Nov 7, 2021

--

Listen

Share

Setup MySQLdb

import pymysql

pymysql.install_as_MySQLdb()

• Add above in settings.py.

• Django backend uses the module named MySQLdb as MySQL backend.
• pymysql make itself indicate to MySQLdb so that django could work.

Setup MySQL engine

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    },
    'real_estate_db': {
            'ENGINE': 'django.db.backends.mysql',
            'NAME': 'real_estate_data',
            'USER': 'root',
            'PASSWORD': '1209',
            'HOST': '127.0.0.1',
            'PORT': '3306',
        }
}

• Add MySQL database engine in settings.py.