No module named ‘MySQLdb Did you install mysqlclient

在Django项目中,若需将MySQLdb替换为pymysql,只需在项目的__init__.py文件中添加两行代码:首先导入pymysql,然后调用pymysql的install_as_MySQLdb()函数。如果未安装pymysql,需要先通过pip install pymysql进行安装。此方法经过验证,可以成功实现替换。
解决办法:
在django项目目录下的__init__.py文件夹中添加代码:
import pymysql
 
pymysql.install_as_MySQLdb()

在这里插入图片描述

如果没装pymysql再装一下
pip install pymysql

亲测有效,学习记录。

D:\BaiduNetdiskDownload\anaconda1\python.exe D:\BaiduNetdiskDownload\PYTHON\eggplantshapeBS1\djangoProject\manage.py runserver localhost:8000 Watching for file changes with StatReloader Exception in thread django-main-thread: Traceback (most recent call last): File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\backends\mysql\base.py", line 16, 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 "D:\BaiduNetdiskDownload\anaconda1\Lib\threading.py", line 1043, in _bootstrap_inner self.run() ~~~~~~~~^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\threading.py", line 994, in run self._target(*self._args, **self._kwargs) ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\utils\autoreload.py", line 64, in wrapper fn(*args, **kwargs) ~~^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\core\management\commands\runserver.py", line 124, in inner_run autoreload.raise_last_exception() ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\utils\autoreload.py", line 86, in raise_last_exception raise _exception[1] File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\core\management\__init__.py", line 394, in execute autoreload.check_errors(django.setup)() ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\utils\autoreload.py", line 64, in wrapper fn(*args, **kwargs) ~~^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\__init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\apps\registry.py", line 116, in populate app_config.import_models() ~~~~~~~~~~~~~~~~~~~~~~~~^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\apps\config.py", line 269, in import_models self.models_module = import_module(models_module_name) ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\importlib\__init__.py", line 88, in import_module return _bootstrap._gcd_import(name[level:], package, level) ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1387, in _gcd_import File "<frozen importlib._bootstrap>", line 1360, in _find_and_load File "<frozen importlib._bootstrap>", line 1331, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 935, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 1026, in exec_module File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\contrib\auth\models.py", line 5, in <module> from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\contrib\auth\base_user.py", line 43, in <module> class AbstractBaseUser(models.Model): ...<123 lines>... ) File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\models\base.py", line 145, in __new__ new_class.add_to_class("_meta", Options(meta, app_label)) ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\models\base.py", line 373, in add_to_class value.contribute_to_class(cls, name) ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\models\options.py", line 238, in contribute_to_class self.db_table, connection.ops.max_name_length() ^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\utils\connection.py", line 15, in __getattr__ return getattr(self._connections[self._alias], item) ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\utils\connection.py", line 62, in __getitem__ conn = self.create_connection(alias) File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\utils.py", line 193, in create_connection backend = load_backend(db["ENGINE"]) File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\utils.py", line 113, in load_backend return import_module("%s.base" % backend_name) File "D:\BaiduNetdiskDownload\anaconda1\Lib\importlib\__init__.py", line 88, in import_module return _bootstrap._gcd_import(name[level:], package, level) ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\BaiduNetdiskDownload\anaconda1\Lib\site-packages\django\db\backends\mysql\base.py", line 18, in <module> raise ImproperlyConfigured( "Error loading MySQLdb module.\nDid you install mysqlclient?" ) from err django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient?
最新发布
09-24
Traceback (most recent call last): File "/usr/local/lib/python3.10/dist-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 "/usr/local/bin/daphne", line 8, in <module> sys.exit(CommandLineInterface.entrypoint()) File "/usr/local/lib/python3.10/dist-packages/daphne/cli.py", line 171, in entrypoint cls().run(sys.argv[1:]) File "/usr/local/lib/python3.10/dist-packages/daphne/cli.py", line 233, in run application = import_by_path(args.application) File "/usr/local/lib/python3.10/dist-packages/daphne/utils.py", line 12, in import_by_path target = importlib.import_module(module_path) File "/usr/lib/python3.10/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1050, in _gcd_import File "<frozen importlib._bootstrap>", line 1027, in _find_and_load File "<frozen importlib._bootstrap>", line 992, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed File "<frozen importlib._bootstrap>", line 1050, in _gcd_import File "<frozen importlib._bootstrap>", line 1027, in _find_and_load File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 688, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 883, in exec_module File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed File "/home/lang/GreaterWMS/./greaterwms/__init__.py", line 4, in <module> django.setup() File "/usr/local/lib/python3.10/dist-packages/django/__init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) File "/usr/local/lib/python3.10/dist-packages/django/apps/registry.py", line 116, in populate app_config.import_models() File "/usr/local/lib/python3.10/dist-packages/django/apps/config.py", line 269, in import_models self.models_module = import_module(models_module_name) File "/usr/lib/python3.10/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1050, in _gcd_import File "<frozen importlib._bootstrap>", line 1027, in _find_and_load File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 688, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 883, in exec_module File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed File "/usr/local/lib/python3.10/dist-packages/django/contrib/auth/models.py", line 3, in <module> from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager File "/usr/local/lib/python3.10/dist-packages/django/contrib/auth/base_user.py", line 49, in <module> class AbstractBaseUser(models.Model): File "/usr/local/lib/python3.10/dist-packages/django/db/models/base.py", line 141, in __new__ new_class.add_to_class("_meta", Options(meta, app_label)) File "/usr/local/lib/python3.10/dist-packages/django/db/models/base.py", line 369, in add_to_class value.contribute_to_class(cls, name) File "/usr/local/lib/python3.10/dist-packages/django/db/models/options.py", line 231, in contribute_to_class self.db_table, connection.ops.max_name_length() File "/usr/local/lib/python3.10/dist-packages/django/utils/connection.py", line 15, in __getattr__ return getattr(self._connections[self._alias], item) File "/usr/local/lib/python3.10/dist-packages/django/utils/connection.py", line 62, in __getitem__ conn = self.create_connection(alias) File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 193, in create_connection backend = load_backend(db["ENGINE"]) File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 113, in load_backend return import_module("%s.base" % backend_name) File "/usr/lib/python3.10/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "/usr/local/lib/python3.10/dist-packages/django/db/backends/mysql/base.py", line 17, in <module> raise ImproperlyConfigured( django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient?
08-29
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值