MySQL-Python与Django 1.5.0:没有名为mysql.base的模块错误

0 投票
1 回答
2239 浏览
提问于 2025-04-17 20:13

我正在尝试通过 python manage.py syncdb 在Django中创建数据库表,但遇到了一个错误 错误是:没有名为mysql.base的模块。我知道网上有很多类似的问题,但没有一个能帮到我。

我的Python版本是:2.7.3 (默认,2012年8月1日,05:16:07) \n[GCC 4.6.3]

Django版本是:(1, 5, 0, 'final', 0)

MySQL-Python版本是:MySQL_python-1.2.4b4-py2.7-linux-i686

系统信息:Linux Marlon 3.5.0-26-generic #42~precise1-Ubuntu SMP 2013年3月11日 22:19:42 UTC i686 athlon i386 GNU/Linux

MySQL版本是:mysql Ver 14.14 Distrib 5.5.29, 适用于debian-linux-gnu (i686) 使用readline 6.2

我的 setting.py 文件内容:

...
DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
    'NAME': 'a',                      # Or path to database file if using sqlite3.
    # The following settings are not used with sqlite3:
    'USER': 'a',
    'PASSWORD': 'a',
    'HOST': 'a',                      # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
    'PORT': '',                      # Set to empty string for default.
  }
}
...

错误代码:

`Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 453, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 272, in fetch_command
klass = load_command_class(app_name, subcommand)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 77, in load_command_class
module = import_module('%s.management.commands.%s' % (app_name, name))
File "/usr/local/lib/python2.7/dist-packages/django/utils/importlib.py", line 35, in import_module
__import__(name)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/syncdb.py", line 8, in <module>
from django.core.management.sql import custom_sql_for_model, emit_post_sync_signal
File "/usr/local/lib/python2.7/dist-packages/django/core/management/sql.py", line 9, in <module>
from django.db import models
File "/usr/local/lib/python2.7/dist-packages/django/db/__init__.py", line 40, in <module>
backend = load_backend(connection.settings_dict['ENGINE'])
File "/usr/local/lib/python2.7/dist-packages/django/db/__init__.py", line 34, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 93, in __getitem__
backend = load_backend(db['ENGINE'])
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 45, in load_backend
raise ImproperlyConfigured(error_msg)
django.core.exceptions.ImproperlyConfigured: 'django.db.backends.mysql' isn't an available database backend.
Try using 'django.db.backends.XXX', where XXX is one of:
u'oracle', u'postgresql_psycopg2', u'sqlite3'
Error was: No module named mysql.base`

而且在交互式命令行中 import MySQLdb 是可以正常工作的。

我哪里做错了?

1 个回答

0

看起来你的Django安装有点问题:它列出了在django.db.backends下可用的包,但不知道为什么没有提到mysql。我建议你彻底删除Django,然后重新安装一遍。

(我也对你在dist-packages下看到Django 1.5感到困惑。dist-packages是用来放发行版提供的包的,而Django 1.5太新了,应该还没有被任何发行版包含。也许你有两个冲突的安装版本?)

撰写回答