- 创建用户
mysql> create user 'allpass'@'%' identified by 'allpass123';
Query OK, 0 rows affected (0.01 sec)
mysql> create database allpass default charset utf8 collate utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on allpass.* to 'allpass'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
本地MySQL :root/wangqi
- 安装mysql-python包
下载地址:https://pan.baidu.com/s/1gdHy9IN
- Django配置,配置settings.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'allpass',
'USER': 'allpass',
'PASSWORD': '*',
'HOST': '*',
'PORT': '3306',
}
}