django默认数据库sqlite3改为mysql
生活随笔
收集整理的這篇文章主要介紹了
django默认数据库sqlite3改为mysql
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
來個自用的完整版的
?
""" Django settings for mysite project.Generated by 'django-admin startproject' using Django 1.11.7.For more information on this file, see https://docs.djangoproject.com/en/1.11/topics/settings/For the full list of settings and their values, see https://docs.djangoproject.com/en/1.11/ref/settings/ """import os# Build paths inside the project like this: os.path.join(BASE_DIR, ...) BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))# Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/1.11/howto/deployment/checklist/# SECURITY WARNING: keep the secret key used in production secret! SECRET_KEY = '+dztub6%(ige!627fq)5gpd^uiwsc4n^yw=0^gv!a5n7v#%a@5'# SECURITY WARNING: don't run with debug turned on in production! DEBUG = True# ALLOWED_HOSTS = ['127.0.0.1', 'localhost'] ALLOWED_HOSTS=["*"]# Application definitionINSTALLED_APPS = ['django.contrib.admin','django.contrib.auth','django.contrib.contenttypes','django.contrib.sessions','django.contrib.messages','django.contrib.staticfiles','cmdb', ]MIDDLEWARE = ['django.middleware.security.SecurityMiddleware','django.contrib.sessions.middleware.SessionMiddleware','django.middleware.common.CommonMiddleware',# 'django.middleware.csrf.CsrfViewMiddleware','django.contrib.auth.middleware.AuthenticationMiddleware','django.contrib.messages.middleware.MessageMiddleware','django.middleware.clickjacking.XFrameOptionsMiddleware', ]ROOT_URLCONF = 'mysite.urls'TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates','DIRS': [os.path.join(BASE_DIR, 'templates')],'APP_DIRS': True,'OPTIONS': {'context_processors': ['django.template.context_processors.debug','django.template.context_processors.request','django.contrib.auth.context_processors.auth','django.contrib.messages.context_processors.messages',],},}, ]WSGI_APPLICATION = 'mysite.wsgi.application'# Database # https://docs.djangoproject.com/en/1.11/ref/settings/#databases# DATABASES = { # 'default': { # 'ENGINE': 'django.db.backends.sqlite3', # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), # # 'ENGINE': 'django.db.backends.mysql', # # 'NAME': os.path.join(BASE_DIR, 'db.sql'), # } # }DATABASES = {# 'default': {# 'ENGINE': 'django.db.backends.sqlite3',# 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),# }'default': {'ENGINE': 'django.db.backends.mysql','HOST': '127.0.0.1', # 地址'NAME': 'cmdb', # 數據庫名'USER': 'appleyuchi', 'PASSWORD': 'appleyuchi','PORT': 3306,} }# Password validation # https://docs.djangoproject.com/en/1.11/ref/settings/#auth-password-validatorsAUTH_PASSWORD_VALIDATORS = [{'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',},{'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',},{'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',},{'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',}, ]# Internationalization # https://docs.djangoproject.com/en/1.11/topics/i18n/LANGUAGE_CODE = 'en-us'TIME_ZONE = 'UTC'USE_I18N = TrueUSE_L10N = TrueUSE_TZ = True# Static files (CSS, JavaScript, Images) # https://docs.djangoproject.com/en/1.11/howto/static-files/STATIC_URL = '/static/' # STATICFILES_DIRS=[(os.path.join(BASE_DIR,'static'))]#for local test STATICFILES_DIRS = (# ('css',os.path.join(STATIC_ROOT,'css').replace('\\','/') ),# ('js',os.path.join(STATIC_ROOT,'js').replace('\\','/') ),('images',os.path.join(BASE_DIR,'images').replace('\\','/') ),# ('upload',os.path.join(STATIC_ROOT,'upload').replace('\\','/') ), )#for pictures ,added by yuchi STATIC_URL = '/static/' STATIC_ROOT = os.path.join(os.path.dirname(__file__),'static')?
總結
以上是生活随笔為你收集整理的django默认数据库sqlite3改为mysql的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: STATIC_URL/STATIC_RO
- 下一篇: RuntimeError: Model