How to Connect MySQL database with Django Project | Beginners Tutorial 2023

If you’re a beginner in web development and looking to connect a MySQL database with your Django project, you’re in the right place. In this tutorial, we’ll walk you through the steps to set up a MySQL database and integrate it with your Django project.

Step 1: Install MySQL

First, you’ll need to install MySQL on your machine if you haven’t already. You can download and install MySQL from the official website or use a package manager such as Homebrew on Mac or Chocolatey on Windows.

Step 2: Configure MySQL

Once MySQL is installed, you’ll need to create a new database for your Django project. Use the MySQL command-line interface or a GUI tool like MySQL Workbench to create a new database and user for your project.

Step 3: Install MySQL Client for Django

Next, you’ll need to install the MySQL client for Django. You can do this using pip by running the following command in your terminal or command prompt:

pip install mysqlclient

Step 4: Configure Django Settings

Now that the MySQL client is installed, you’ll need to configure your Django project to use the MySQL database. Open your project’s settings.py file and update the DATABASES setting to use the MySQL backend:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'your_database_name',
        'USER': 'your_username',
        'PASSWORD': 'your_password',
        'HOST': 'localhost',
        'PORT': '3306',
    }
}

Step 5: Migrate and Test

Finally, run the following commands to apply the database migrations and start your Django project:

python manage.py makemigrations
python manage.py migrate
python manage.py runserver

Now your Django project should be connected to the MySQL database. You can start building your web applications using the power of Django and MySQL!

Conclusion

Connecting a MySQL database with a Django project is a crucial step in web development. By following the steps outlined in this tutorial, you can seamlessly integrate MySQL with your Django project and start building powerful web applications. We hope this beginner’s tutorial has been helpful to you. Happy coding!