MySQL默认帐户凭据_Django mysql数据库凭据读取默认文件

我将从另一个conf文件向django项目提供mySql凭据。

早些时候它还可以正常工作,但现在在我重新安装了我的ubuntu之后它就停止工作了。在

在设置.py:DATABASES = {

'default': {

'ENGINE': 'django.db.backends.mysql',

'OPTIONS': {

'read_default_file': './connection.cnf',

}

}

}

在连接.cnf:

^{pr2}$

另外,conf文件的位置如下:rajiv@ubuntu:~/djangoProjects/test$ ls -l

total 9

drwxrwxrwx 1 root root 4096 Dec 28 11:04 test

drwxrwxrwx 1 root root 4096 Dec 27 14:00 testApp

-rwxrwxrwx 1 root root 103 Dec 3 00:37 connection.cnf

-rwxrwxrwx 1 root root 252 Oct 15 11:36 manage.py

给出的误差如下:rajiv@ubuntu:~/djangoProjects/test$ python manage.py runserver

Performing system checks...

Warning: World-writable config file '/home/rajiv/djangoProjects/test/connection.cnf' is ignored

Unhandled exception in thread started by

Traceback (most recent call last):

File "/usr/local/lib/python2.7/dist-packages/django/utils/autoreload.py", line 226, in wrapper

fn(*args, **kwargs)

File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/runserver.py", line 116, in inner_run

self.check(display_num_errors=True)

File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 426, in check

include_deployment_checks=include_deployment_checks,

File "/usr/local/lib/python2.7/dist-packages/django/core/checks/registry.py", line 75, in run_checks

new_errors = check(app_configs=app_configs)

File "/usr/local/lib/python2.7/dist-packages/django/core/checks/model_checks.py", line 28, in check_all_models

errors.extend(model.check(**kwargs))

File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 1170, in check

errors.extend(cls._check_fields(**kwargs))

File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 1247, in _check_fields

errors.extend(field.check(**kwargs))

File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/__init__.py", line 925, in check

errors = super(AutoField, self).check(**kwargs)

File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/__init__.py", line 208, in check

errors.extend(self._check_backend_specific_checks(**kwargs))

File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/__init__.py", line 317, in _check_backend_specific_checks

return connections[db].validation.check_field(self, **kwargs)

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/validation.py", line 18, in check_field

field_type = field.db_type(connection)

File "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/__init__.py", line 625, in db_type

return connection.data_types[self.get_internal_type()] % data

File "/usr/local/lib/python2.7/dist-packages/django/db/__init__.py", line 36, in __getattr__

return getattr(connections[DEFAULT_DB_ALIAS], item)

File "/usr/local/lib/python2.7/dist-packages/django/utils/functional.py", line 33, in __get__

res = instance.__dict__[self.name] = self.func(instance)

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 184, in data_types

if self.features.supports_microsecond_precision:

File "/usr/local/lib/python2.7/dist-packages/django/utils/functional.py", line 33, in __get__

res = instance.__dict__[self.name] = self.func(instance)

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/features.py", line 53, in supports_microsecond_precision

return self.connection.mysql_version >= (5, 6, 4) and Database.version_info >= (1, 2, 5)

File "/usr/local/lib/python2.7/dist-packages/django/utils/functional.py", line 33, in __get__

res = instance.__dict__[self.name] = self.func(instance)

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 359, in mysql_version

with self.temporary_connection():

File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__

return self.gen.next()

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 564, in temporary_connection

cursor = self.cursor()

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 231, in cursor

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

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 204, in _cursor

self.ensure_connection()

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 199, in ensure_connection

self.connect()

File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 95, in __exit__

six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 199, in ensure_connection

self.connect()

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 171, in connect

self.connection = self.get_new_connection(conn_params)

File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 264, in get_new_connection

conn = Database.connect(**conn_params)

File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect

return Connection(*args, **kwargs)

File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 206, in __init__

super(Connection, self).__init__(*args, **kwargs2)

django.db.utils.OperationalError: (1045, "Access denied for user 'rajiv'@'localhost' (using password: NO)")

不知道为什么会出错。

如果有什么不对劲的地方,有人能给我一些建议吗。在

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值