首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Django和MySQL,无法访问以进行连接,数据库错误:1045

问Django和MySQL,无法访问以进行连接,数据库错误:1045
EN

Stack Overflow用户
提问于 2016-07-21 06:25:03
回答 2查看 2K关注 0票数 0

你好,我正在和几个人一起做一个项目。我们使用的是django 1.9,我的mysql,有人设置了django来连接mysql,然后为我们其余的人写了关于我们需要下载什么来连接python和mysql的说明。我正确地安装了mysql,但在访问数据库时遇到了问题。我们都应该有权访问数据库,但我一直得到django.db.utils.OperationalError: (1045, "Access denied for user 'django'@'localhost' (using password: YES)"),即使我只是在终端中输入mysql,我得到ERROR 1045 (28000): Access denied for user 'stevenJing'@'localhost' (using password: NO),然后输入mysql -u root -p,我得到ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)。我不确定我需要做什么来修复这个问题,因为我甚至不能做python3 manage.py runserver,因为我得到了一个很大的错误。

代码语言:javascript
复制
    Performing system checks...

Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x10434a510>
Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection
    self.connect()
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 171, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 264, in get_new_connection
    conn = Database.connect(**conn_params)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/MySQLdb/connections.py", line 204, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'django'@'localhost' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/utils/autoreload.py", line 226, in wrapper
    fn(*args, **kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/core/management/commands/runserver.py", line 116, in inner_run
    self.check(display_num_errors=True)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/core/management/base.py", line 426, in check
    include_deployment_checks=include_deployment_checks,
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/core/checks/registry.py", line 75, in run_checks
    new_errors = check(app_configs=app_configs)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/core/checks/model_checks.py", line 28, in check_all_models
    errors.extend(model.check(**kwargs))
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/models/base.py", line 1178, in check
    errors.extend(cls._check_fields(**kwargs))
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/models/base.py", line 1255, in _check_fields
    errors.extend(field.check(**kwargs))
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 925, in check
    errors = super(AutoField, self).check(**kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 208, in check
    errors.extend(self._check_backend_specific_checks(**kwargs))
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 317, in _check_backend_specific_checks
    return connections[db].validation.check_field(self, **kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/mysql/validation.py", line 18, in check_field
    field_type = field.db_type(connection)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 625, in db_type
    return connection.data_types[self.get_internal_type()] % data
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/__init__.py", line 36, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/utils/functional.py", line 33, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 184, in data_types
    if self.features.supports_microsecond_precision:
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/utils/functional.py", line 33, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-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 "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/utils/functional.py", line 33, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 359, in mysql_version
    with self.temporary_connection():
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/contextlib.py", line 59, in __enter__
    return next(self.gen)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 564, in temporary_connection
    cursor = self.cursor()
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 231, in cursor
    cursor = self.make_debug_cursor(self._cursor())
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 204, in _cursor
    self.ensure_connection()
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection
    self.connect()
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/utils.py", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/utils/six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection
    self.connect()
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/base/base.py", line 171, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 264, in get_new_connection
    conn = Database.connect(**conn_params)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/MySQLdb/connections.py", line 204, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (1045, "Access denied for user 'django'@'localhost' (using password: YES)")

这是我的Django的settings.py

代码语言:javascript
复制
DATABASES = {
    'default': {
       # 'ENGINE': 'mysql.connector.django',
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'lolProject',
        'USER': 'django',
        'PASSWORD': 'django-pass',
        'HOST': '127.0.0.1',
        #'OPTIONS':{'read_default_file': ''},
        #'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    }
}

设置数据库的人是MySQL的新手,我也是,我们如何才能获得它,所以如果有人从我们的git库中拉出或克隆,他们就可以访问数据库。

EN

回答 2

Stack Overflow用户

发布于 2016-07-21 08:21:59

Mysql权限

此错误是因为django用户无权访问lolProject数据库。您可以使用GRANT命令来纠正这一点。django用户需要很多特权,因为它需要在迁移过程中创建和删除表,所以应该这样做。

代码语言:javascript
复制
GRANT ALL ON lolproject.* TO 'django'@'localhost';

通常通过以mysql -u root用户身份打开控制台来执行此操作,其中根用户是默认安装的帐户,通常没有与之关联的密码。

现在,如果每个人的计算机上都有一台mysql服务器,这就很好了。如果每个人都连接到同一台计算机,那么它应该是

代码语言:javascript
复制
GRANT ALL ON lolproject.* TO 'django'@'%';

由于从您的存储库中提取的每个人都需要访问权限,因此您应该在settings.py中使用IP而不是本地主机

Sqlite

你有没有考虑过使用sqlite?它几乎不需要任何设置,并且每个从您的存储库克隆或提取的人都会获得当前数据库的一个副本(如果已将其添加到存储库)。

票数 2
EN

Stack Overflow用户

发布于 2016-07-21 06:37:50

如果人们正在提取您的代码,而您希望他们访问您的数据库,那么他们可能不应该使用“localhost”。如果您在本地主机上运行时也收到此错误,则这是权限问题。

首先要做的是查看是否可以使用命令行MySQL或其他MySQL客户端使用这些凭据进行登录。

我经常遇到这样的错误(不幸的),这通常是因为我没有在MySQL中正确添加用户。我注意到,仅仅添加'%‘并不能说明本地主机,在授予用户权限时,我通常必须在' user '@'%’之外添加'user'@' localhost‘。

编辑:为了授予权限,您需要以root用户身份登录到mysql,通常使用如下命令:

代码语言:javascript
复制
% mysql -u root -P mysql

"-P“表示您必须提供超级用户/管理员密码,最后一个"mysql”是要使用的模式。显然,您需要管理员访问权限才能做到这一点。

然后,在较新版本的MySQL中,首先创建用户:

代码语言:javascript
复制
> create user  'stevenJing'@'localhost' identified by 'password';

这实际上是一个与'stevenJing'@'%‘不同的用户,所以如果你要同时从本地主机和远程主机连接,你实际上需要这两个主机。

然后,您需要向该用户授予权限:

代码语言:javascript
复制
> grant all privileges on <schema>.* to 'stevenJing'@'localhost';

其中schema显然是您的Django schema (上面Django设置中的lolProject)。此外,当然,要授予该用户从其他地方登录的权限:

代码语言:javascript
复制
> grant all privileges on <schema>.* to 'stevenJing'@'%';
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/38491869

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档