如何使用MySQLdb与Python和Django在OSX 10.6?

这是OSX 10.6用户经常讨论的问题，但我还没有找到一个有效的解决方案。下面是我的设置:

Python 2.6.1 64bit Django 1.2.1 " MySQL 5.1.47 osx10.6 64bit

我用——no-site-packages创建了一个virtualenvwrapper，然后安装Django。当我激活virtualenv并运行python manage.py syncdb时，我得到这个错误:

Traceback (most recent call last):
File "manage.py", line 11, in <module>
  execute_manager(settings)
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/core/management/__init__.py", line 438, in execute_manager
  utility.execute()
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/core/management/__init__.py", line 379, in execute
  self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/core/management/__init__.py", line 257, in fetch_command
  klass = load_command_class(app_name, subcommand)
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/core/management/__init__.py", line 67, in load_command_class
  module = import_module('%s.management.commands.%s' % (app_name, name))
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/utils/importlib.py", line 35, in import_module
  __import__(name)
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/core/management/commands/syncdb.py", line 7, in <module>
from django.core.management.sql import custom_sql_for_model, emit_post_sync_signal
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/core/management/sql.py", line 5, in <module>
from django.contrib.contenttypes import generic
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/contrib/contenttypes/generic.py", line 6, in <module>
  from django.db import connection
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/db/__init__.py", line 75, in <module>
  connection = connections[DEFAULT_DB_ALIAS]
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/db/utils.py", line 91, in __getitem__
  backend = load_backend(db['ENGINE'])
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/db/utils.py", line 32, in load_backend
  return import_module('.base', backend_name)
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/utils/importlib.py", line 35, in import_module
  __import__(name)
File "/Users/joerobinson/.virtualenvs/dj_tut/lib/python2.6/site-packages/django/db/backends/mysql/base.py", line 14, in <module>
  raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

我还安装了MySQL for Python适配器，但没有效果(可能我安装不正确?)

有人之前处理过这个问题吗?

当前回答

对我来说，重新安装mysql-python就解决了这个问题

pip uninstall mysql-python
pip install mysql-python

2017-01-04 16:07:25

其他回答

我也有同样的错误，pip install MySQL-python为我解决了这个问题。

备选安装:

如果没有pip, easy_install MySQL-python应该可以工作。如果你的python是由打包系统管理的，你可能不得不使用该系统(例如sudo apt-get install…)

下面，Soli指出，如果你收到以下错误:

mysql_config未找到

．.．然后还有一个进一步的系统依赖问题。解决方法因系统而异，但对于debian衍生系统:

使用apt-get install python-mysqldb

2010-11-12 22:55:07

运行Ubuntu 13.10 64位时，以下操作对我来说非常有效:

sudo apt-get install libmysqlclient-dev
sudo apt-get install python-dev

现在，导航到你的virtualenv(例如env文件夹)并执行以下命令:

sudo ./bin/pip install mysql-python

实际上，我在一个单独的问题中找到了解决方案，下面引用它:

If you have created the virtualenv with the --no-site-packages switch (the default), then system-wide installed additions such as MySQLdb are not included in the virtual environment packages. You need to install MySQLdb with the pip command installed with the virtualenv. Either activate the virtualenv with the bin/activate script, or use bin/pip from within the virtualenv to install the MySQLdb library locally as well. Alternatively, create a new virtualenv with system site-packages included by using the --system-site-package switch.

我认为这也适用于OSX。唯一的问题是获得用于安装libmysqlclient-dev和python-dev的等效命令，因为它们需要编译我猜是mysql-python。

希望这能有所帮助。

2014-02-22 19:44:28

Mysql_config必须在路径上。在Mac上

export PATH=$PATH:/usr/local/mysql/bin/
pip install MySQL-python

2012-06-14 20:04:34

试试下面的命令。他们为我工作:

brew install mysql-connector-c 
pip install MySQL-python

2015-05-11 08:26:24

我是如何让它工作的:

virtualenv -p python3.5 env/test

在找到我的环境后:

pip install pymysql
pip install django

然后，我运行startproject，在manage.py中，我添加了这个:

+ try:
+     import pymysql
+     pymysql.install_as_MySQLdb()
+ except:
+     pass

同时，更新了内部设置:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'foobar_db',
        'USER': 'foobaruser',
        'PASSWORD': 'foobarpwd',
    }
}

我也有configparser==3.5.0安装在我的virtualenv，不确定这是否是必需的…

希望能有所帮助，

2016-06-28 17:45:04

如何使用MySQLdb与Python和Django在OSX 10.6?

推荐文章

最新文章

标签