django 连接mysql

测试积点老人

替换默认数据库配置

1. vi sites/settings.py
   
2. '''　
   
3. DATABASES = {
   
4.     'default': {
   
5.         'ENGINE': 'django.db.backends.sqlite3',
   
6.         'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
   
7.     }
   
8. }
   
9. '''
   
10. 
    
11. DATABASES = {
    
12.     'default': {
    
13.         'ENGINE': 'django.db.backends.mysql',
    
14.         'NAME':'django',
    
15.         'USER':'root',
    
16.         'HOST':'localhost',
    
17.         'PASSWORD':'',
    
18.         'PORT':'3306',
    
19. 
    
20.     }
    
21. }

复制代码

设置数据库编码

1. vi /etc/my.cnf
   
2. 
   
3. [mysqld]
   
4. datadir=/var/lib/mysql
   
5. socket=/var/lib/mysql/mysql.sock
   
6. user=mysql
   
7. # Disabling symbolic-links is recommended to prevent assorted security risks
   
8. symbolic-links=0
   
9. 
   
10. character_set_server=utf8
    
11. 
    
12. [mysqld_safe]
    
13. log-error=/var/log/mysqld.log
    
14. pid-file=/var/run/mysqld/mysqld.pid
    
15. 
    
16. 
    
17. [client]
    
18. default-character_set=utf8

复制代码

创建数据库

1. mysql -uroot
   
2. 
   
3. create database django character set utf8
   
4. 
   
5. exit
   
6. 
   
7. sudo service mysqld restart

复制代码

Miss_love

学习