当我最初使用我的localhost作为我正在处理的Django应用程序时,我遇到了这个错误。我正在尝试连接到新服务器时获取它。我不记得我做了什么来解决它。
Performing system checks...
Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x031F1E88>
Traceback (most recent call last):
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection
self.connect()
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 194, in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\base.py", line 236, in get_new_connection
return Database.connect(**conn_params)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-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: The specified module could not be found.\r\n")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\utils\autoreload.py", line 225, in wrapper
fn(*args, **kwargs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\commands\runserver.py", line 120, in inner_run
self.check(display_num_errors=True)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\base.py", line 364, in check
include_deployment_checks=include_deployment_checks,
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\management\base.py", line 351, in _run_checks
return checks.run_checks(**kwargs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\checks\registry.py", line 73, in run_checks
new_errors = check(app_configs=app_configs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\core\checks\model_checks.py", line 27, in check_all_models
errors.extend(model.check(**kwargs))
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\models\base.py", line 1200, in check
errors.extend(cls._check_fields(**kwargs))
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\models\base.py", line 1272, in _check_fields
errors.extend(field.check(**kwargs))
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\models\fields\__init__.py", line 894, in check
errors = super().check(**kwargs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\models\fields\__init__.py", line 206, in check
errors.extend(self._check_backend_specific_checks(**kwargs))
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\models\fields\__init__.py", line 303, in _check_backend_specific_
checks
return connections[db].validation.check_field(self, **kwargs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\validation.py", line 21, in check_field
field_type = field.db_type(self.connection)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\models\fields\__init__.py", line 648, in db_type
return connection.data_types[self.get_internal_type()] % data
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\utils\functional.py", line 36, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\base.py", line 133, in data_types
if self.features.supports_microsecond_precision:
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\utils\functional.py", line 36, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\features.py", line 65, in supports_microsecond_pre
cision
return self.connection.mysql_version >= (5, 6, 4)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\utils\functional.py", line 36, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\base.py", line 345, in mysql_version
with self.temporary_connection() as cursor:
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\contextlib.py", line 81, in __enter__
return next(self.gen)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 576, in temporary_connection
cursor = self.cursor()
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor
return self._cursor()
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor
self.ensure_connection()
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection
self.connect()
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection
self.connect()
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\base\base.py", line 194, in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\django\db\backends\mysql\base.py", line 236, in get_new_connection
return Database.connect(**conn_params)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "C:\Users\LL67773\AppData\Local\Programs\Python\Python36-32\lib\site-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: The specified module could not be found.\r\n")
我通过我的MySQL工作台连接到数据库,不确定这是否有助于缩小问题范围。
为了澄清,我尝试使用这个问题的大部分答案:
发布于 2018-08-30 16:49:10
再次运行MySql安装程序并重新配置它以使用旧式身份验证
https://stackoverflow.com/questions/-100002509
复制相似问题