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