首页 > 解决方案 > MySQLdb 库找不到图像

问题描述

我正在尝试使用MySQLdb库。

我已经使用安装库pip install mysqlclient

运行时:import MySQLdb as db我有以下错误:

import MySQLdb as db
  File "/Users/Solal/anaconda3/lib/python3.7/site-packages/MySQLdb/__init__.py", line 19, in <module>
    from . import _mysql
ImportError: dlopen(/Users/Solal/anaconda3/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so, 2): Library not loaded: /usr/local/opt/mysql/lib/libmysqlclient.21.dylib
  Referenced from: /Users/Solal/anaconda3/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so
  Reason: image not found

这就是我的MySQLdb仓库中的所有文件:

constants
__pycache__
converters.py
_exceptions.py
cursors.py
_mysql.cpython-37m-darwin.so
release.py
compat.py
times.py
connections.py

我也没有文件mysql/usr/local/opt

我在网上找到了如下修复: sudo ln -s /usr/local/Cellar/mysql/5.7.10/lib/libmysqlclient.dylib /usr/local/lib/libmysqlclient.18.dylib

但是我的/usr/local/Cellar/文件夹里什么都没有

标签: pythonmysql

解决方案


我仅通过运行就成功地使其工作:

brew install mysql


推荐阅读