ImportError: No module named 'MySQLdb'

最新推荐文章于 2025-10-31 10:38:00 发布

原创最新推荐文章于 2025-10-31 10:38:00 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

Python 同时被 3 个专栏收录

120 篇文章

订阅专栏

报错

47 篇文章

订阅专栏

数据库

9 篇文章

订阅专栏

本文介绍了一种常见问题，即在使用Python的SQLAlchemy库时遇到的“没有名为MySQLdb的模块”错误，并提供了解决方案。通过安装pymysql库并将其设置为MySQLdb的替代品，可以轻松解决此问题。

报错

Traceback (most recent call last):
  File "/home/as/anaconda3/envs/superset/bin/superset", line 12, in <module>
    from superset.cli import manager
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/superset/__init__.py", line 89, in <module>
    utils.pessimistic_connection_handling(db.engine)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/flask_sqlalchemy/__init__.py", line 893, in engine
    return self.get_engine(self.get_app())
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/flask_sqlalchemy/__init__.py", line 910, in get_engine
    return connector.get_engine()
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/flask_sqlalchemy/__init__.py", line 545, in get_engine
    self._engine = rv = sqlalchemy.create_engine(info, **options)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/__init__.py", line 387, in create_engine
    return strategy.create(*args, **kwargs)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/strategies.py", line 80, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 110, in dbapi
    return __import__('MySQLdb')
ImportError: No module named 'MySQLdb'

解决
打开home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/dialects/mysql/mysqldb.py
添加

import pymysql
pymysql.install_as_MySQLdb()