django添加mysql数据库_09-python-django一步一步(添加mysql数据库)

3.5在settings中添加数据库

DATABASES = {

'default': {

'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql',

'sqlite3' or 'oracle'.

'NAME': 'serManager',                      # Or path to database

file if using sqlite3.

# The following settings are not used with sqlite3:

'USER': 'root',

'PASSWORD': '123456',

'HOST': '',                      #

Empty for localhost through domain sockets or '127.0.0.1' for localhost through

TCP.

'PORT': '',                      #

Set to empty string for default.

}

}

创建数据库

root@ubuntu:/opt/serManager/serManager#mysql -uroot

-p123456

mysql> create database serManager default

charset='utf8';

Query OK, 1 row affected (0.05 sec)

mysql>

3.6设置settings加载静态文件

cp -frp bootstrap

/opt/serManager/sshCMD/Templates/

root@ubuntu:/opt/serManager/serManager#vim settings.py

MEDIA_ROOT =

'/opt/serManager/sshCMD/Templates/bootstrap/'

root@ubuntu:/opt/serManager/serManager#vim urls.py

from django.conf.urls import patterns,

include, url

#add by hans 20130906

from sshCMD.views import index

from django.conf import settings

# Uncomment the next two lines to enable

the admin:

# from django.contrib import admin

# admin.autodiscover()

urlpatterns = patterns('',

#

Examples:

#

url(r'^$', 'serManager.views.home', name='home'),

# url(r'^serManager/',

include('serManager.foo.urls')),

#

Uncomment the admin/doc line below to enable admin documentation:

#

url(r'^admin/doc/', include('django.contrib.admindocs.urls')),

#

Uncomment the next line to enable the admin:

# url(r'^admin/', include(admin.site.urls)),

(r'^$',index),

(r'bootstrap/(?P.*)$','django.views.static.serve',{'document_root':settings.MEDIA_ROOT,}),

)

访问测试