Using MySQL Database with Django Project

Mahabubur Rahman
0
Initially Django support Sqlit and Postgresql Database, but by installing the MySQL client package we can use MySQL database with the Django project.

So now I will describe the necessary configuration required to connect Django with the MySQL database.

Step - 1: Installing MySQL Client
Install MySQL client through pip using the command 

pip install mysqlclient

Step - 2: Setting Database Connection 
Open the settings.py file of the Django project. Here update the database connection settings as bellow

DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'test_dashboard', 'USER': 'test_user', 'PASSWORD': 'test_pass', 'HOST': 'localhost', 'PORT': '3306', } }
Here -
ENGINE : database engine.
NAME : database user name.
PASSWORD : database user password.
HOST : database server host.
PORT : database port.


Step - 3: Make Migrations
Now run the below commands - 

python manage.py makemigrations
python manage.py migrate


This will migrate all Django Models to MySQL schema.


This is how you can connect your Django web application with the MySQL database.


If this article was helpful leave a comment.

Post a Comment

0Comments
Post a Comment (0)