如何使用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适配器，但没有效果(可能我安装不正确?)

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

当前回答

我在Windows 8 64位系统上无法使用PIP。 Easy_install mysql-python适合我。如果pip不起作用，可以使用easy_install来避免在windows上构建二进制文件。

2015-07-04 02:57:26

其他回答

我是如何让它工作的:

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

我升级到OSX Mavericks和Pycharm 3，开始得到这个错误，我使用pip和easy install，得到这个错误:

命令“/usr/bin/clang”失败，退出状态为1。

所以我需要更新到Xcode 5，并再次尝试使用pip安装。

pip install mysql-python

解决了所有的问题。

2013-11-27 20:33:54

如果你正在使用python3，那么试试这个(我的操作系统是Ubuntu 16.04):

sudo apt-get install python3-mysqldb

2017-03-08 02:46:42

此问题是由于MySQL for Python适配器安装不完整/不正确造成的。具体来说，我必须编辑mysql_config文件的路径，使其指向/usr/local/mysql/bin/mysql_config——本文将更详细地讨论:http://dakrauth.com/blog/entry/python-and-django-setup-mac-os-x-leopard/

2010-09-23 22:35:03

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

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

2015-05-11 08:26:24

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

推荐文章

最新文章

标签