How to Configure Django for MySQL Database Use: Development vs. Production?

Setting Up Django to Utilize MySQL

Convenience vs. Persistent Setup

Upon installing Django and creating a project, you may notice a discrepancy in setup. While a tutorial might suggest a "set and forget" approach, allowing Django to work out of the box, you may find yourself running python manage.py runserver myip:port to launch your server. Is this intentional, or will it cause issues later?

In actuality, running the server manually is a standard practice during development. This allows for quick iteration and testing on your local machine. However, for production purposes or sharing with others, it's necessary to configure Django to run a persistent server. Refer to the Django documentation on Deploying Django for guidance on this.

Integrating MySQL

To use MySQL with Django, you'll need to modify the settings.py file located in your project directory. Within the DATABASES dictionary, set the following parameters:

Parameter	Description
ENGINE	Designate the Django database backend ('django.db.backends.mysql')
NAME	Specify the name of your database
USER	Provide the database username
PASSWORD	Enter the database password
HOST	Specify the host address, either 'localhost' or an IP address if the database is hosted elsewhere
PORT (optional)	Define the port on which MySQL listens (typically '3306')

Setting Default Character Set and MySQL Connector

To ensure proper character handling, create your MySQL database with the UTF-8 character set using the following SQL command:

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_bin

If you're using Oracle's MySQL connector, update the ENGINE entry in the settings.py file to:

'ENGINE': 'mysql.connector.django',

Prerequisites and Alternatives

Don't forget to install MySQL on your operating system (brew install mysql for macOS). Additionally, Python 3 requires the mysqlclient package instead of mysql-client (pip3 install mysqlclient).

The above is the detailed content of How to Configure Django for MySQL Database Use: Development vs. Production?. For more information, please follow other related articles on the PHP Chinese website!