Django将默认的SQLite更换为MySQL

注释默认的SQLite3配置

$projectName/settings.py
'''
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    }
}
'''

添加MySQL配置(配置你自己的mysql库前提是你已经有能够供自己使用的MySQL库了)

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', #固定配置
        'HOST': '127.0.0.1',#mysql地址
        'PORT': '3306',#端口号
        'NAME': 'mydjango',#库名（组名）
        'USER': 'root',#用户
        'PASSWORD': '123456',#密码
        'OPTIONS': {'init_command': "SET sql_mode='STRICT_TRANS_TABLES'", },
    }
}

 安装mysql的客户端（假如有，则跳过）

pip install mysqlclient

到 manage.py文件所在的目录下执行迁移命令

python manage.py migrate

出现如下日志

(venv) D:\pycharm\Django_01\myapp>python manage.py migrate
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying admin.0003_logentry_add_action_flag_choices... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying auth.0009_alter_user_last_name_max_length... OK
  Applying auth.0010_alter_group_name_max_length... OK
  Applying auth.0011_update_proxy_permissions... OK
  Applying sessions.0001_initial... OK

验证

使用navicat或其他工具登录，查看