执行命令 python manage.py makemigrations时抛出以下错误

Traceback (most recent call last):
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\backends\mysql\base.py", line 15, in <module>
import MySQLdb as Database
ModuleNotFoundError: No module named 'MySQLdb' The above exception was the direct cause of the following exception: Traceback (most recent call last):
File "manage.py", line 21, in <module>
main()
File "manage.py", line 17, in main
execute_from_command_line(sys.argv)
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\core\management\__init__.py", line 371, in execute_from_command_line
utility.execute()
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\core\management\__init__.py", line 347, in execute
django.setup()
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\__init__.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\apps\registry.py", line 112, in populate
app_config.import_models()
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\apps\config.py", line 198, in import_models
self.models_module = import_module(models_module_name)
File "D:\Program Files\Python\Python37-32\lib\importlib\__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 677, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 728, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\contrib\auth\models.py", line 2, in <module>
from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\contrib\auth\base_user.py", line 47, in <module>
class AbstractBaseUser(models.Model):
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\models\base.py", line 114, in __new__
new_class.add_to_class('_meta', Options(meta, app_label))
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\models\base.py", line 315, in add_to_class
value.contribute_to_class(cls, name)
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\models\options.py", line 205, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\__init__.py", line 33, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\utils.py", line 202, in __getitem__
backend = load_backend(db['ENGINE'])
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\utils.py", line 110, in load_backend
return import_module('%s.base' % backend_name)
File "D:\Program Files\Python\Python37-32\lib\importlib\__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "D:\Program Files\Python\Python37-32\lib\site-packages\django\db\backends\mysql\base.py", line 20, in <module>
) from err
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.
Did you install mysqlclient?

问题原因:MySQLdb只支持Python2.*,还不支持3.* ,但是在settings中配置的数据库为MySql,所以执行时会报错

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'autotest',
'USER': 'root',
'PASSWORD': 'root',
'HOST': '127.0.0.1',
'PORT': '3306' }
}

 解决方法1:若想继续使用MySql数据库,则可用PyMySQL代替,安装命令为 pip install PyMySQL

在settings.py同级目录中的_init_.py文件中加入代码(只需更改此次,所创建的应用不需再设置,如果只在应用下的_init_.py文件中更改,则只适用该应用)

import pymysql

pymysql.install_as_MySQLdb()

再次执行:

D:\autotestplat>python manage.py makemigrations
Migrations for 'product':
product\migrations\0001_initial.py
- Create model Product
Migrations for 'apitest':
apitest\migrations\0001_initial.py
- Create model Apis
- Create model Apistep
- Create model Apitest
- Add field Apitest to apistep
Migrations for 'bug':
bug\migrations\0001_initial.py
- Create model Bug

 解决方法2:安装mysqlclient,可用命令pip install mysqlclient

最新文章

  1. Hibernate二级缓存配置
  2. 使用grub手动引导linux和windows
  3. Asp.net MVC进入请求管道的过程
  4. git stash
  5. #python基础学习模块:marshal 对象的序列化
  6. 【Java】 实现一个简单文件浏览器(2)
  7. Android中获取电池电量
  8. python绝技 — 搜寻蓝牙设备
  9. Chapter 3:Speech Production and Perception
  10. 使用gulp-babel转换Es6出现exports is not defined 问题
  11. Data Dictionary 数据字典
  12. PAT B1015 德才论 (25 分)
  13. Linux系统源码安装软件过程中configure选项-prefix的作用
  14. Linux Device Tree
  15. AI学习路径
  16. 华为mate 10 pro安装失败,提示没有未包含任何证书
  17. 复数 一级ADT实现
  18. pyextend库-merge可迭代对象合并函数
  19. 读取bq26500电池电量 Driver
  20. jqgrid常用操作

热门文章

  1. 通过Thread Pool Executor类解析线程池执行任务的核心流程
  2. PHP全栈开发(四): HTML 学习(3. form 表单)
  3. 220726 T2 Multisets (思维)
  4. 动态代理(JDK、CGLIB)
  5. 一篇文章让你搞懂Java中的静态代理和动态代理
  6. do-while循环的使用
  7. C语言客房管理&amp;酒店管理
  8. java中的垃圾回收算法与垃圾回收器
  9. 测试架构师CAP原理(最简单)
  10. Spark基本知识