How to Connect MySQL Database in Django Project

Tutorial Link - http://studygyaan.com/django/how-to-export-excel-file-with-django

In this tutorial, you will learn how to Export Excel Spreadsheet with Django. You will learn how to do read-write operations on excel sheets. Styling Excel spreadsheet with XLWT Library. And writing to Existing Excel Workbook using XLWT.

Setup

Create a folder and put all the files inside it.
Create a virtual environtment - virtualenv env
Activate VirtualENV - source env/bin/activate
Run requirements.txt - pip3 install -r requirements.txt
Run the Application - python3 manage.py runserver
Go to - http://localhost:8000/

Change Database Credentials with your Database - `blog/settings.py`

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'your_database_name', # example - blog_data
        'USER': 'your_mysql_user',
        'PASSWORD': 'your_mysql_password',
        'HOST': 'localhost',
        'PORT': '80',
    }
}

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!