配置Django使用MySQL資料庫的例子

1、安裝mysql (Django 安裝略)：

[root@itchenyi-1 Django-1.3.3]# yum install mysql-server mysql-devel
[root@itchenyi-1 Django-1.3.3]# yum install MySQL-python

2、設定Mysql 資料庫 及使用者：

[root@itchenyi-1 Django-1.3.3]# service mysqld start
[root@itchenyi-1 Django-1.3.3]# mysql -u root -p

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

type 'help;' or '＼h' for help. Type '＼c' to clear the current input statement.

mysql> create database itchenyi_db;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON itchenyi_db.* TO 'itchenyi'@'localhost' IDENTIFIED BY 'your password';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
3、create a django project：

[root@itchenyi-1 Django-1.3.3]# django-admin.py startproject itchenyi

4、編輯 建立的project 設定檔(settings.py)：

[root@itchenyi-1 Django-1.3.3]# vi itchenyi/settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'itchenyi_db',                      # Or path to database file if using sqlite3.
        'USER': 'itchenyi',                      # Not used with sqlite3.
        'PASSWORD': 'your password',                  # Not used with sqlite3.
        'host': '',                      # set to empty string for localhost. Not used with sqlite3.
        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
    }
}

5、切換到建立的project 建立資料庫和表：

[root@itchenyi-1 Django-1.3.3]# cd itchenyi/
[root@itchenyi-1 itchenyi]# python manage.py syncdb
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site

You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Username (Leave blank to use 'root'): itchenyi
E-mail address: itchenyi@gmail.com
Password:
Password (again):
Superuser created successfully.
Installing custom SQL ...
Installing indexes ...
No fixtures found.

6、簡單驗證：

[root@itchenyi-1 itchenyi]# python manage.py Shell
Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22)
[gcc 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> import MySQLdb
>>> db = MySQLdb.connect(user='itchenyi',db='itchenyi_db',passwd='your password'
,host='localhost')
>>>