配置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')
>>>