blocks|key|56418|text|我认为在Mac+64位上做这件事可能会有一些奇怪的地方(如果你在谷歌上搜索这个问题的话，也会发现很多)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|56419|我遇到过它，你可以做几件事：|56420|覆盖环境|56421|您可以更改DYLD_LIBRARY_PATH环境变量，它告诉链接器在哪里查找动态库(.so文件等)。您说您还下载了64位版本的MySQL，所以无论在哪里安装，都要更改您在这里看到的路径：|offset|length|style|CODE|56422|在贝壳中：|56423|export+DYLD_LIBRARY_PATH=/usr/local/mysql/lib/|56424|然后运行python，看看是否可以import+MySQLdb。|56425|如果这有效，您可以通过更改您的外壳配置文件(很可能是.bash_profile)来使其永久化。|56426|使用自制|56427|我真的不喜欢在确保MySQL和Python以及所有正确的体系结构和分别安装它们的过程中无所事事。我运行的是homebrew，它是Mac的一种包管理器。如果您安装了它，您可以很容易地处理这个问题：|56428|brew+install+python|unordered-list-item|56429|brew+install+mysql|56430|/usr/local/share/python/easy_install+mysql-python|56431|请注意，/usr/local中安装了自制软件，所以您应该在/usr/bin和/bin之前将/usr/local/bin添加到您的PATH中，否则您会非常困惑为什么python是不同的。|56432|您也可以将/usr/local/share/python添加到您的PATH中，以使其永久化。|56433|entityMap|0|LINK|mutability|MUTABLE|url|https://brew.sh/^0|0|0|0|5|H|0|0|0|1A|0|4|6|H|E|0|Q|D|0|0|1H|8|1H|8|0|0|0|J|0|0|I|0|0|1D|0|4|A|T|8|12|4|19|E|1S|4|29|6|0|5|N|X|4|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1I|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1J|8|@$H|1K|I|1L|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1M|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1N|8|@$H|1O|I|1P|J|K]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1Q|8|@$H|1R|I|1S|J|K]|$H|1T|I|1U|J|K]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1V|8|@$H|1W|I|1X|J|K]]|9|@]|A|$]]|$1|T|3|U|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1Z|8|@$H|20|I|21|J|K]]|9|@$H|22|I|23|1|24]]|A|$]]|$1|X|3|Y|5|Z|7|25|8|@$H|26|I|27|J|K]]|9|@]|A|$]]|$1|10|3|11|5|Z|7|28|8|@$H|29|I|2A|J|K]]|9|@]|A|$]]|$1|12|3|13|5|Z|7|2B|8|@$H|2C|I|2D|J|K]]|9|@]|A|$]]|$1|14|3|15|5|6|7|2E|8|@$H|2F|I|2G|J|K]|$H|2H|I|2I|J|K]|$H|2J|I|2K|J|K]|$H|2L|I|2M|J|K]|$H|2N|I|2O|J|K]|$H|2P|I|2Q|J|K]]|9|@]|A|$]]|$1|16|3|17|5|6|7|2R|8|@$H|2S|I|2T|J|K]|$H|2U|I|2V|J|K]]|9|@]|A|$]]|$1|18|3|-4|5|6|7|2W|8|@]|9|@]|A|$]]]|19|$1A|$5|1B|1C|1D|A|$1E|1F]]]]

I think there might be slight quirks with doing this on Mac 64-bit (and if you google this problem shows up a lot too).
I've run into it, and there are a couple things you can do:
<h3>Override the environment</h3>
You can change the <code>DYLD_LIBRARY_PATH</code> environment variable, which tells the linker where to look for dynamic libraries (.so files and such). You said you also downloaded the 64-bit version of MySQL, so where ever it's installed, change the path you see here:
In a shell:
<code>export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/</code>
And then run <code>python</code> and see if you can <code>import MySQLdb</code>.
If that works, you can make this permanent by altering your shell profile (<code>.bash_profile</code>, most likely).
<h3>Use homebrew</h3>
I don't really like mucking around with making sure MySQL and Python and all that are correct architectures and installing them separately. I run <a href="https://brew.sh/" rel="nofollow noreferrer"><code>homebrew</code></a>, which is a sort of package manager for Mac. If you install that, you can pretty easily take care of this issue:
<ul>
<li><code>brew install python</code></li>
<li><code>brew install mysql</code></li>
<li><code>/usr/local/share/python/easy_install mysql-python</code></li>
</ul>
Do note that homebrew installs into <code>/usr/local</code>, so you should add <code>/usr/local/bin</code> to your <code>PATH</code>, ahead of <code>/usr/bin</code> and <code>/bin</code>, otherwise you'll get really confused why <code>python</code> is different.
You can add <code>/usr/local/share/python</code> to your <code>PATH</code> as well, to make it permanent.

blocks|key|56468|text|在@birryree评论的帮助下，我发现了这个问题。我可能会更好地遵循@birryree在他的回答中所建议的程序，但我以前确实尝试过，它起了作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|56469|正如所建议的那样，我做到了：|56470|file+/Users/aj/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-ix86_64.egg-tmp/_mysql.so|code-block|syntax|javascript|56471|要得到：[...]:+Mach-O+bundle+i386所以，错误的架构。从那以后，我对mysql和python也做了同样的操作，以确保：file+$(which+python)给出了：|offset|length|style|CODE|56472|/Library/Frameworks/Python.framework/Versions/2.7/bin/python:+Mach-O+universal+binary+with+2+architectures
/Library/Frameworks/Python.framework/Versions/2.7/bin/python+(for+architecture+i386):+++Mach-O+executable+i386
/Library/Frameworks/Python.framework/Versions/2.7/bin/python+(for+architecture+x86_64):+Mach-O+64-bit+executable+x86_64|56473|和file+$(which+mysql)|56474|/usr/local/mysql/bin/mysql:+Mach-O+64-bit+executable+x86_64|56475|因此，我卸载了mysql包：sudo+pip+uninstall+mysql-python，并再次安装了它。但这样做，我意识到我以前的错误，当安装这个软件包。我第一次输入：|56476|sudo+ARCHFLAGS='-arch+ix86_64'+python+setup.py+build+(然后“安装”)|56477|架构名称是错误的，应该是‘-archx86_64’，没有"i"，所以它只是忽略了我的标志并安装了32位。|56478|安装下载的64位mysql包的适当命令(从源文件夹)：|56479|sudo+ARCHFLAGS='-arch+x86_64'+python+setup.py+build
sudo+ARCHFLAGS='-arch+x86_64'+python+setup.py+install|56480|entityMap^0|0|0|0|4|P|1Y|K|0|0|1|J|0|0|E|V|0|0|1G|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|19|8|@$K|1A|L|1B|M|N]|$K|1C|L|1D|M|N]]|9|@]|A|$]]|$1|O|3|P|5|F|7|1E|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|1F|8|@$K|1G|L|1H|M|N]]|9|@]|A|$]]|$1|S|3|T|5|F|7|1I|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|1J|8|@$K|1K|L|1L|M|N]]|9|@]|A|$]]|$1|W|3|X|5|6|7|1M|8|@$K|1N|L|1O|M|N]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1P|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|12|3|13|5|F|7|1R|8|@]|9|@]|A|$G|H]]|$1|14|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|15|$]]

With the help of the comment from @birryree I found the problem. I would probably be better off following the procedure suggested by @birryree in his answer but I did try this before and it worked:

As suggested, I did:

<pre><code>file /Users/aj/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-ix86_64.egg-tmp/_mysql.so
</code></pre>

To get: <code>[...]: Mach-O bundle i386</code>
So, wrong architecture. From there I did the same with mysql and python just to be sure:
<code>file $(which python)</code> gave:

<pre><code>/Library/Frameworks/Python.framework/Versions/2.7/bin/python: Mach-O universal binary with 2 architectures
/Library/Frameworks/Python.framework/Versions/2.7/bin/python (for architecture i386): Mach-O executable i386
/Library/Frameworks/Python.framework/Versions/2.7/bin/python (for architecture x86_64): Mach-O 64-bit executable x86_64
</code></pre>

And <code>file $(which mysql)</code>:

<pre><code>/usr/local/mysql/bin/mysql: Mach-O 64-bit executable x86_64
</code></pre>

So I uninstalled the mysql-python package: <code>sudo pip uninstall mysql-python</code> and installed it again. But doing this I realized my previous mistake while installing this package. First time I typed:

<code>sudo ARCHFLAGS='-arch ix86_64' python setup.py build</code> (and "install" afterwards)

The architecture name was wrong, should be '-arch x86_64', no "i", so it just ignored my flag and installed the 32bit.

The proper commands to install the downloaded mysql-python package for 64bit (from the source folder):

<pre><code>sudo ARCHFLAGS='-arch x86_64' python setup.py build
sudo ARCHFLAGS='-arch x86_64' python setup.py install
</code></pre>

blocks|key|17059|text|非常重要！|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|17060|如前所述，请确保您正在运行64位版本的mysql.这是很容易忽略这个细节，特别是如果你已经从雪豹升级。(我当然知道)。|17061|如果您不确定是否要删除系统中较早版本的mysql，请参阅下面的文章：http://johnmcostaiii.net/2011/removing-mysql-osx-lion/|17062|entityMap|0|LINK|mutability|MUTABLE|url|http://johnmcostaiii.net/2011/removing-mysql-osx-lion/^0|0|5|0|D|3|0|Y|1I|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|J|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

VERY IMPORTANT!

As mentioned above, please make sure you are running the 64-bit version of mysql. It's easy to overlook this detail especially if you've upgraded from Snow Leopard. (I certainly did).

if you're not sure about removing the older version of mysql on your system, refer to this post: <a href="http://johnmcostaiii.net/2011/removing-mysql-osx-lion/" rel="nofollow">http://johnmcostaiii.net/2011/removing-mysql-osx-lion/</a>

blocks|key|16383|text|还请确保您也在运行Python+64位。我运行mysql+64位和Python+32位，因此出现了“但架构错误”错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|16384|entityMap|0|LINK|mutability|MUTABLE|url|http://www.python.org/ftp/python/2.7.3/python-2.7.3-macosx10.6.dmg^0|9|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Also make sure you are running <a href="http://www.python.org/ftp/python/2.7.3/python-2.7.3-macosx10.6.dmg" rel="nofollow">Python 64-bit</a> too. I was running mysql 64 bit and Python 32bit so got the 'but wrong architecture' error

blocks|key|1883456|text|我也遇到了同样的问题，在修复了64位问题后，MySQLdb非常头痛(它还抱怨libmysqlclient.18.dylib在哪里)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1883457|我认为是时候切换到正式的MysQL+Python连接器了吗？|1883458|sudo+pip+install+mysql-connector-python|code-block|syntax|javascript|1883459|或从：http://dev.mysql.com/downloads/connector/python/下载|offset|length|1883460|文档：http://dev.mysql.com/doc/refman/5.5/en/connector-python.htm|1883461|它易于使用，并与PEP+249兼容(PythonDBAPI2.0版)。|1883462|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/connector/python/|1|http://dev.mysql.com/doc/refman/5.5/en/connector-python.htm^0|0|0|0|3|1C|0|0|3|1N|1|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@$K|14|L|15|1|16]]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@$K|18|L|19|1|1A]]|A|$]]|$1|O|3|P|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

I had the same problem, and a lot of headache with MySQLdb after fixing the 64bit issue (it was complaining also about where is libmysqlclient.18.dylib).

I think it's time to switch to the official MysQL Python Connector?

<pre><code>sudo pip install mysql-connector-python
</code></pre>

Or download it from: <a href="http://dev.mysql.com/downloads/connector/python/" rel="nofollow">http://dev.mysql.com/downloads/connector/python/</a>

Documentation: <a href="http://dev.mysql.com/doc/refman/5.5/en/connector-python.htm" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/connector-python.htm</a>

It's easy to use and also compatible with PEP 249 (Python DB API version 2.0).

I installed everything successfully, or so I thought:

<ul>
<li>MySQL 5.5 for x86_64.</li>
<li>Python 2.7, x86_64.</li>
<li>mysql-python 1.2.3, x86_64.</li>
</ul>

But when I try:

<pre><code>import MySQLdb
</code></pre>

I get:

<pre><code> ImportError: 
dlopen(/Users/aj/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-ix86_64.egg-tmp/_mysql.so, 2): 
no suitable image found. 
Did find: 
/Users/aj/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.6-ix86_64.egg-tmp/_mysql.so: mach-o, 
but wrong architecture
</code></pre>

What else can I be missing?

My system is of course 64bit version as well, <code>uname -a</code> gives:

<pre><code>Darwin ajmacbook.local 11.1.0 Darwin Kernel Version 11.1.0: Tue Jul 26 16:07:11 PDT 2011; root:xnu-1699.22.81~1/RELEASE_X86_64 x86_64
</code></pre>

I think I have read most SO answers and Google results on the subject, can't think of anything else to try. Any suggestion would be appreciated.

mysql-python installation problems (on mac os x lion)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我成功地安装了所有的东西，或者我是这么想的：MySQL 5.5表示x86_64。Python2.7，x86_64.MySQLpython1.2.3，x86_64。但当我尝试：import MySQLdb我得到：    ImportError: dlopen(/Users/aj/.python-eggs/MySQL_py...

问mysql-python安装问题(在mac x lion上)
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql-python安装问题(在mac x lion上)EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql-python安装问题(在mac x lion上)
EN