_mysql_exceptions.operational error 1044拒绝使用Djang的用户访问

Question

我试图使用Python Django从服务器A访问到服务器“apple”的mysql数据库。相关声明如下

import settings
os.environ['DJANGO_SETTINGS_MODULE'] = runconfig.django_settings_module
from django.db import connection

class Writer(object):
  def __init__(self):

  def submission(self,pars):
    d = connection.cursor()

运行此命令会产生如下错误：

_mysql_exceptions.OperationalError: (1044, "Access denied for user 'username'@'ice.cse.connell.edu' to database 'mydatabase'")

runconfig.py的内容是

# Django setting module 
django_settings_module = 'settings'

奇怪的是，我可以从服务器“ice”远程登录到服务器“apple”：

$ mysql -u username -ppassword -h apple

我一直在研究这个问题，但仍然找不到答案。这个问题把我逼疯了！

下面是我settings.py的前几行。因为太长了，我没有把它全部发出去。但如果有人需要更多，我可以粘贴所有的内容。

# Django settings for mydatabase project.

DEBUG = False
TEMPLATE_DEBUG = DEBUG

ADMINS = (
    # ('Your Name', 'your_email@domain.com'),
)

MANAGERS = ADMINS

DATABASE_ENGINE = 'mysql'          # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
DATABASE_NAME = 'mydatabase'  # Or path to database file if using sqlite3.
DATABASE_USER = 'username'             # Not used with sqlite3.
DATABASE_PASSWORD = 'password'         # Not used with sqlite3.
DATABASE_HOST = 'apple'            # Set to empty string for localhost. Not used with sqlite3.
DATABASE_PORT = ''             # Set to empty string for default. Not used with sqlite3.

-----------------------------------------------------------------------------------------

附加帖子

根据Sid的建议修改settings.py之后：

#DATABASE_ENGINE = 'mysql'           
#DATABASE_NAME = 'mydatabase'   
#DATABASE_USER = 'username'             
#DATABASE_PASSWORD = 'password'         
#DATABASE_HOST = 'apple'  
#DATABASE_PORT = ''     

DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': 'mydatabase',
    'USER': 'username',
    'PASSWORD': 'password',
    'HOST': 'apple',
    'PORT': '',
  }
}

命令行输入和错误消息是

>>> import runconfig
>>> 
>>> import os
>>> import sys
>>> import settings
>>> #from django.conf import settings
... 
>>> os.environ['DJANGO_SETTINGS_MODULE'] = runconfig.django_settings_module
>>> 
>>> from django.db import connection
>>> c = connection.cursor()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.6/site-packages/django/db/backends/dummy/base.py", line 15, in complain
    raise ImproperlyConfigured, "You haven't set the DATABASE_ENGINE setting yet."
django.core.exceptions.ImproperlyConfigured: You haven't set the DATABASE_ENGINE setting yet.