最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
配置Django使用MySQL数据库的例子
时间:2015-03-11 编辑:简简单单 来源:一聚教程网
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')
>>>
相关文章
- MySQL数据库主主互备模式的配置 09-22
- MySQL数据库需安全配置与注意事项 08-19
- MySQL数据库服务器集群配置详解介绍 09-22
- Mysql 数据库双机热备的配置方法 06-10
- MySQL数据库5.0的my.cnf配置选项概述 09-03
- win11内核隔离和内存完整性介绍 10-31