Reason: image not found mysql_config not found

最新推荐文章于 2021-04-07 10:40:49 发布

suhido

最新推荐文章于 2021-04-07 10:40:49 发布

阅读量158

点赞数

分类专栏： pymysql 文章标签：数据库 python

本文链接：https://blog.youkuaiyun.com/suhido/article/details/84054380

版权

pymysql 专栏收录该内容

0 篇文章

订阅专栏

本文解决在使用Python和MySQLdb进行数据库操作时遇到的动态链接库未找到的问题，通过安装MySQL客户端并设置环境变量来解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Python 2.7.2 (default, Aug 22 2011, 13:53:27)
[GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "build/bdist.macosx-10.6-x86_64/egg/MySQLdb/__init__.py", line 19, in <module>
File "build/bdist.macosx-10.6-x86_64/egg/_mysql.py", line 7, in <module>
File "build/bdist.macosx-10.6-x86_64/egg/_mysql.py", line 6, in __bootstrap__
ImportError: dlopen(/Users/seaeast/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-x86_64.egg-tmp/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib
Referenced from: /Users/seaeast/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-x86_64.egg-tmp/_mysql.so
Reason: image not found
>>> exit
Use exit() or Ctrl-D (i.e. EOF) to exit
>>>
zsh: suspended python

解决办法
sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib

sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

EnvironmentError: mysql_config not found

sudo ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql