blocks|key|233456|text|确保您不仅拥有MySql-Python，还拥有实际的MySql。MySQL-python正在尝试加载mysql库，其位置应该类似于/usr/local/mysql-VERSION/lib。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233457|尝试运行|233458|mdfind+libmysqlclient|code-block|syntax|javascript|233459|在命令行上。浏览一下这些结果，如果您没有看到缺少的文件(libmysqlclient.18.dylib)，那么您可能没有正确安装mysql。|233460|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Make sure you have not just MySql-Python, but the actual MySql. MySQL-python is trying to load the mysql library, which should be somewhere like /usr/local/mysql-VERSION/lib. 

Try running

<pre><code>mdfind libmysqlclient
</code></pre>

on the command line. Scan through those results and if you don't see the file it's missing (libmysqlclient.18.dylib) then you probably don't have mysql installed properly.

blocks|key|234338|text|你能给我们看看你的settings.py代码吗？您还可以尝试编辑mysql_config文件的路径，使其指向本文中更详细讨论的/usr/local/mysql/bin/mysql_config：http://dakrauth.com/blog/entry/python-and-django-setup-mac-os-x-leopard/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|234339|entityMap|0|LINK|mutability|MUTABLE|url|http://dakrauth.com/blog/entry/python-and-django-setup-mac-os-x-leopard/^0|2P|20|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]]]]

Can you show us your settings.py code?
you can also try edit the path to the mysql_config file to point to /usr/local/mysql/bin/mysql_config as discussed in better detail in this article:
 <a href="http://dakrauth.com/blog/entry/python-and-django-setup-mac-os-x-leopard/" rel="nofollow">http://dakrauth.com/blog/entry/python-and-django-setup-mac-os-x-leopard/</a>

blocks|key|233539|text|从您的评论中可以看出，libmysqlclient+dylib是使用非绝对库名称路径安装的。这与OS上的标准实践相反，OS在这方面与大多数其他Unix-y系统不同。您应该能够通过使用install_name_tool修改.so文件中的路径来永久修复该问题(至少在您的下一次升级之前)，或者您可以通过确保您的Django实例运行时定义了以下环境变量来使其工作：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|233540|export+DYLD_LIBRARY_PATH=/usr/local/mysql/lib|code-block|syntax|javascript|233541|您还可以通过在/usr/local/lib中创建到/usr/local/mysql/lib中的dylib的符号链接来使其工作，因为/usr/local/lib位于默认的动态加载搜索路径上，所以(未经测试！)类似于：|233542|sudo+ln+-s+/usr/local/mysql/lib/libmysqlclient.18.dylib+/usr/local/lib/libmysqlclient.18.dylib|233543|更好的长期解决方案是不使用Python+import+MySQLdb+error+-+Mac+10.6中建议的损坏的MySQL客户端安装。|233544|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/4730787/python-import-mysqldb-error-mac-10-6/4731333#4731333^0|B|E|2J|H|0|0|7|E|P|K|1T|E|0|0|D|12|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|14|8|@$9|15|A|16|B|C]|$9|17|A|18|B|C]|$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1B|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1C|8|@]|D|@$9|1D|A|1E|1|1F]]|E|$]]|$1|Q|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

From your comments, it appears that the <code>libmysqlclient</code> dylib was installed with a non-absolute library name path. That's contrary to standard practice on OS X which is different from most other Unix-y systems in this respect. You should be able to permanently fix the problem (at least until your next upgrade) by modifying the path in the .so file by using <code>install_name_tool</code> or you can make it work by ensuring your Django instance is running with the following environment variable defined:

<pre><code>export DYLD_LIBRARY_PATH=/usr/local/mysql/lib
</code></pre>

You also might be able to get it to work by creating a symlink in <code>/usr/local/lib</code> to the dylib in <code>/usr/local/mysql/lib</code> since <code>/usr/local/lib</code> is on the default dynamic load search path, so (untested!) something like:

<pre><code>sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/lib/libmysqlclient.18.dylib
</code></pre>

A better long-term solution is to not use a broken MySQL client installation as suggested in <a href="https://stackoverflow.com/questions/4730787/python-import-mysqldb-error-mac-10-6/4731333#4731333">Python import MySQLdb error - Mac 10.6</a>.

blocks|key|3109197|text|我没有足够的名气来评论Ned+Deily上面的答案:)，但环境变量方法在修复拼写错误后对我有效；它应该是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3109198|export+DYLD_LIBRARY_PATH=/usr/local/mysql/lib|code-block|syntax|javascript|3109199|如果您选择这种方法，我会建议您做两件事；确保您不会通过使用以下命令来破坏任何其他DYLD_LIBRARY_PATH设置|3109200|export+DYLD_LIBRARY_PATH=$DYLD_LIBARY_PATH:/usr/local/mysql/lib|3109201|并将其放入您的.bashrc文件中，这样您就不必记得在每次终端会话中设置它。|3109202|与symlink选项相比，这种方法的好处是它将允许找到所有mysql+dylib文件，而不仅仅是您专门用symlink链接的文件。|3109203|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I don't have enough reputation to comment on Ned Deily's answer above :), but the environment variable method worked for me, after fixing the typo; it should be:

<pre><code>export DYLD_LIBRARY_PATH=/usr/local/mysql/lib
</code></pre>

If you go that route I would suggest two things; make sure you don't bash any other DYLD_LIBRARY_PATH settings by using

<pre><code>export DYLD_LIBRARY_PATH=$DYLD_LIBARY_PATH:/usr/local/mysql/lib
</code></pre>

and put it in your .bashrc file so you don't have to remember to set it in each terminal session.

The benefit to this method over the symlink option is that it will allow all the mysql dylib files to be found, not just the one(s) you specifically symlink.

blocks|key|2895284|text|使用mysql的homebrew安装，这对我很有效：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2895285|$+mdfind+libmysqlclient
/usr/local/Cellar/mysql/5.7.9/lib/libmysqlclient.20.dylib
/usr/local/Cellar/mysql/5.7.9/lib/libmysqlclient.a
/usr/local/Cellar/mysql/5.6.27/lib/libmysqlclient.18.dylib
/usr/local/Cellar/mysql/5.6.27/lib/libmysqlclient.a
/usr/local/Cellar/mysql/5.6.26/lib/libmysqlclient.18.dylib
/usr/local/Cellar/mysql/5.6.26/lib/libmysqlclient.a

$+sudo+ln+-s+/usr/local/Cellar/mysql/5.6.27/lib/libmysqlclient.18.dylib+/usr/local/lib/libmysqlclient.18.dylib|code-block|syntax|javascript|2895286|entityMap|0|LINK|mutability|MUTABLE|url|http://brew.sh/^0|2|5|8|8|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Using a <a href="http://brew.sh/" rel="nofollow">homebrew</a> installation of <code>mysql</code>, this worked for me:

<pre><code>$ mdfind libmysqlclient
/usr/local/Cellar/mysql/5.7.9/lib/libmysqlclient.20.dylib
/usr/local/Cellar/mysql/5.7.9/lib/libmysqlclient.a
/usr/local/Cellar/mysql/5.6.27/lib/libmysqlclient.18.dylib
/usr/local/Cellar/mysql/5.6.27/lib/libmysqlclient.a
/usr/local/Cellar/mysql/5.6.26/lib/libmysqlclient.18.dylib
/usr/local/Cellar/mysql/5.6.26/lib/libmysqlclient.a

$ sudo ln -s /usr/local/Cellar/mysql/5.6.27/lib/libmysqlclient.18.dylib /usr/local/lib/libmysqlclient.18.dylib
</code></pre>

blocks|key|3109231|text|您可能最近升级了mysql。在使用brew将MySql从5.6升级到5.7时，我遇到了这个问题。这肯定破坏了一些库，但将mysql重新链接回5.6解决了这个问题。因此，首先使用以下命令查看之前的mysql版本：brew+info+mysql，然后使用brew+switch+mysql+5.6.22命令切换回该版本。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3109232|entityMap^0|2X|F|3H|O|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

You probably have upgraded mysql recently. I got this issue when I upgraded MySql from 5.6 to 5.7 with brew. This definitely broke some libs, but relinking mysql back to 5.6 fixed the issue.
So first see what mysql version you had previously with:
<code>brew info mysql</code> and after switch back to that version using <code>brew switch mysql 5.6.22</code> command for example.

I'm starting down the path of learning Python/Django and have hit my first snag. When attempting to set my database in <code>settings.py</code>, the internal server fails with:

<pre><code>File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 16, in &lt;module&gt;
raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: dlopen(/Users/rob/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg-tmp/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib
Referenced from: /Users/rob/.python-eggs/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg-tmp/_mysql.so
Reason: image not found
</code></pre>

There are a lot of solutions that I've found, mostly involving the explicit definition of my <code>DYLD_LIBRARY_PATH</code> value, but that doesn't work for me. <code>MysQL-Python</code> is installed (v1.2.3).

Any idea what I might need to do to push through this?

Thanks.

UPDATE

<pre><code>DATABASES = {
 'default': {
 'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
 'NAME': 'django_tutorial', # Or path to database file if using sqlite3.
 'USER': 'root', # Not used with sqlite3.
 'PASSWORD': '', # Not used with sqlite3.
 'HOST': '', # Set to empty string for localhost. Not used with sqlite3.
 'PORT': '', # Set to empty string for default. Not used with sqlite3.
 }
}
</code></pre>

libmysqlclient.18.dylib image not found when using MySQL from Django on OS X

数据库

服务器

Django

Python

MySQL

Unix

我开始学习Python/Django，并且遇到了我的第一个障碍。当尝试在settings.py中设置我的数据库时，内部服务器失败，出现以下错误：File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 16, in <...

问在OS X上使用Django中的MySQL时找不到libmysqlclient.18.dylib镜像
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OS X上使用Django中的MySQL时找不到libmysqlclient.18.dylib镜像EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OS X上使用Django中的MySQL时找不到libmysqlclient.18.dylib镜像
EN