Configuring MySQL in Django

1. Configuration fields

Configure database fields in the setting file: The database needs to be created manually in advance: statements (CREATE DATABASE TestDB charset "UTF8";)

1DATABASES = {2     'default': {3         'ENGINE':'Django.db.backends.mysql',4         'NAME':'Rfsdata',#the name of the database5         'USER':'Root',#Database user name6         'PASSWORD':'123456',7         'HOST':'192.168.70.129',8         'PORT':'3306',9     }Ten}

View Code

Py2 to MySQLdb support is good, py3 words generally use PYMYSQL database engine,

Add the following statement to the __init__.py of the project: means using Pymysql instead of MYSQLDB

Import Pymysql
Pymysql.install_as_mysqldb ()

Configuring MySQL in Django