天天看点

python开发怎么对接mysql_如何将django开发服务器连接到MySQL数据库?

在我开始之前,请尊重我是一个新手,问我你还需要什么信息来解决这个问题,而不是结束这个问题或其他什么。;)好的。我正在尝试将Django开发服务器连接到一个MySQL数据库,该数据库正托管在远程服务器上。我已经安装了MySQL和MySQL Python,并在“settings.py”中设置了这些设置:DATABASES = {

'default': {

'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.

'NAME': 'database_name', # Or path to database file if using sqlite3.

'USER': 'database_user', # Not used with sqlite3.

'PASSWORD': 'database_password', # Not used with sqlite3.

'HOST': 'db9.subsys.no', # Set to empty string for localhost. Not used with sqlite3.

'PORT': '', # Set to empty string for default. Not used with sqlite3.

}

}

当我尝试使用python manage.py runserver启动开发人员服务器时,我得到:Traceback (most recent call last):

File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 91, in inner_run

self.validate(display_num_errors=True)

File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 266, in validate

num_errors = get_validation_errors(s, app)

File "/Library/Python/2.7/site-packages/django/core/management/validation.py", line 103, in get_validation_errors

connection.validation.validate_field(e, opts, f)

File "/Library/Python/2.7/site-packages/django/db/backends/mysql/validation.py", line 14, in validate_field

db_version = self.connection.get_server_version()

File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 411, in get_server_version

self.cursor()

File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 306, in cursor

cursor = self.make_debug_cursor(self._cursor())

File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 387, in _cursor

self.connection = Database.connect(**kwargs)

File "build/bdist.macosx-10.7-intel/egg/MySQLdb/__init__.py", line 81, in Connect

File "build/bdist.macosx-10.7-intel/egg/MySQLdb/connections.py", line 187, in __init__

_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'db9.subsys.no' (60)")

当我把'HOST': 'db9.subsys.no'改成'HOST': ''时,我得到的是:Traceback (most recent call last):

File "/Library/Python/2.7/site-packages/django/core/management/commands/runserver.py", line 91, in inner_run

self.validate(display_num_errors=True)

File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 266, in validate

num_errors = get_validation_errors(s, app)

File "/Library/Python/2.7/site-packages/django/core/management/validation.py", line 103, in get_validation_errors

connection.validation.validate_field(e, opts, f)

File "/Library/Python/2.7/site-packages/django/db/backends/mysql/validation.py", line 14, in validate_field

db_version = self.connection.get_server_version()

File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 411, in get_server_version

self.cursor()

File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 306, in cursor

cursor = self.make_debug_cursor(self._cursor())

File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 387, in _cursor

self.connection = Database.connect(**kwargs)

File "build/bdist.macosx-10.7-intel/egg/MySQLdb/__init__.py", line 81, in Connect

File "build/bdist.macosx-10.7-intel/egg/MySQLdb/connections.py", line 187, in __init__

_mysql_exceptions.OperationalError: (1045, "Access denied for user 'database_user'@'localhost' (using password: YES)")

是不能使用开发服务器连接到MySQL,还是需要对数据库进行某种配置?如果您有答案或需要更多信息,请回复。

非常感谢提前!

下一篇: DOM与SAX