django.db.utils.operationalerror:(2059，“身份验证插件‘缓存\u sha2 \u密码’”)

qnyhuwrf  于 2021-06-20  发布在  Mysql
关注(0)|答案(5)|浏览(376)

我正在尝试连接我的django项目mysite到mysql。我在mysql中创建了一个用户，并授予它访问该项目的所有权限。以下是我对settings.py所做的更改：

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

现在，当我尝试使用 python3 manage.py makemigrations ，我得到以下错误：

django.db.utils.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory")</code></pre>

完整的堆栈跟踪如下所示：

Traceback (most recent call last):
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection
self.connect()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 194, in connect
self.connection = self.get_new_connection(conn_params)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 236, in get_new_connection
return Database.connect(**conn_params)
File "/usr/lib/python3/dist-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args,**kwargs)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args,**kwargs2)
_mysql_exceptions.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory")

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

Traceback (most recent call last):
File "manage.py", line 15, in <module>
execute_from_command_line(sys.argv)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/management/__init__.py", line 371, in execute_from_command_line
utility.execute()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/management/__init__.py", line 365, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/management/base.py", line 288, in run_from_argv
self.execute(*args,**cmd_options)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/management/base.py", line 332, in execute
self.check()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/management/base.py", line 364, in check
include_deployment_checks=include_deployment_checks,
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/management/base.py", line 351, in _run_checks
return checks.run_checks(**kwargs)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/checks/registry.py", line 73, in run_checks
new_errors = check(app_configs=app_configs)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/core/checks/model_checks.py", line 27, in check_all_models
errors.extend(model.check(**kwargs))
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/models/base.py", line 1200, in check
errors.extend(cls._check_fields(**kwargs))
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/models/base.py", line 1272, in _check_fields
errors.extend(field.check(**kwargs))
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 894, in check
errors = super().check(**kwargs)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 206, in check
errors.extend(self._check_backend_specific_checks(**kwargs))
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 303, in _check_backend_specific_checks
return connections[db].validation.check_field(self,**kwargs)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/validation.py", line 21, in check_field
field_type = field.db_type(self.connection)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/models/fields/__init__.py", line 648, in db_type
return connection.data_types[self.get_internal_type()] % data
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/utils/functional.py", line 36, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 133, in data_types
if self.features.supports_microsecond_precision:
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/utils/functional.py", line 36, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/mysql/features.py", line 65, in supports_microsecond_precision
return self.connection.mysql_version >= (5, 6, 4)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/utils/functional.py", line 36, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 345, in mysql_version
with self.temporary_connection() as cursor:
File "/usr/lib/python3.5/contextlib.py", line 59, in __enter__
return next(self.gen)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 576, in temporary_connection
cursor = self.cursor()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 255, in cursor
return self._cursor()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 232, in _cursor
self.ensure_connection()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection
self.connect()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 216, in ensure_connection
self.connect()
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/base/base.py", line 194, in connect
self.connection = self.get_new_connection(conn_params)
File "/home/prabhjeet/.local/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 236, in get_new_connection
return Database.connect(**conn_params)
File "/usr/lib/python3/dist-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args,**kwargs)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args,**kwargs2)
django.db.utils.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory")

如何解决此错误？我在ubuntu16.04平台上使用python3。

mysqlpythonpython-3.xmysql-pythondjango

5条答案

按热度按时间
nwsw7zdq

nwsw7zdq1#

在mysql 8.0中，默认的身份验证插件是“caching\u sha2\u password”，这会导致身份验证插件问题（错误2059），您可以在mysql workbench中创建一个新用户，并将其设置为标准身份验证。

赞(0）分享  回复(0）举报  2021-06-20
n6lpvg4x

n6lpvg4x2#

问题是（可能）你的（新）mysql版本。
从版本8.04开始，mysql使用缓存\u sha2 \u密码作为默认的身份验证插件，以前使用过mysql \u本机\u密码（这会导致与需要mysql \u本机\u密码身份验证的旧服务的兼容性问题）。
可能的解决方案：
将mysql服务器降级到低于该版本，或者更改身份验证插件（基于用户）
例如，创建用户时：

CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
赞(0）分享  回复(0）举报  2021-06-20
hpxqektj

hpxqektj3#

实际上，没有必要降级mysql服务器。遵循这两个步骤，它应该会起作用：
第一步：更改mysql配置为使用mysql\u本地\u密码。编辑mysqld正在使用的ini文件之一。你可以看到哪个是我的命令

mysqld --verbose --help

确保这一行

default-authentication-plugin=mysql_native_password

第2步：创建新用户或更改现有用户。要创建一个新的mysql\u native\u password：

CREATE USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';

以及改变用户

ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';

顺便说一句，@kolïu ya也指出了这一步

赞(0）分享  回复(0）举报  2021-06-20
kh212irz

kh212irz4#

此错误通常在db用户没有对数据库的所有访问权限时出现
运行此命令：

ALTER  USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';
  • 确保您的mysql服务器正在运行。
赞(0）分享  回复(0）举报  2021-06-20
5sxhfpxr

5sxhfpxr5#

@kol_ya使用create user'username'@'localhost'创建了一个新用户，通过'password'标识mysql_native_密码；其中username=creation of new username and password=current password to login for root（用缓存\u sha2创建的用户名）。这一步允许我连接到mysql server 8.0.13，而不会出现缓存sha2身份验证错误。找了好几个线程的解决方案，但这一个就这样起了作用。谢谢@kol\u ya
对有2个问题的人的建议。在服务器端，确保您的用户身份验证类型是标准的，不缓存\u sha2 \u密码。

赞(0）分享  回复(0）举报  2021-06-20
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com