python - 无法在 Windows 上安装正确版本的 mysql(8.0.13)

Question

我是一名 Windows 用户，对 django 和数据库非常陌生。我目前的小组项目需要使用django和mysql。我的队友(macOS 用户)已经构建了一个 django web，我试图通过在 virtualenv 上运行它来运行该 web。我尝试通过以下方式下载所有必需的软件包输入pip install -rrequirements.txt。虽然它下载了大部分软件包，但它不允许我安装mysql==8.0.13。我尝试了其他方法例如 pip install mysql==8.0.13 甚至在 ubuntu bash 上尝试。

但是，我总是收到此消息......

(virtualenv) C:\Users\ed>pip install mysql==8.0.13

Collecting mysql==8.0.13 Could not find a version that satisfies the requirement mysql==8.0.13 (from versions: 0.0.1, 0.0.2) No matching distribution found for mysql==8.0.13**

所以即使经过多次尝试，我也找不到解决方案，所以当我输入时'py manage.py runserver' 或 'python manage.py runserver'，结果显示如下...

(virtualenv) C:\kim....\projectsite>py manage.py runserver

System check identified no issues (0 silenced).
Unhandled exception in thread started by <function check_errors.<locals>.wrapper at 0x03585618>
Traceback (most recent call last):
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection
    self.connect()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 194, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\mysql\base.py", line 227, in get_new_connection
    return Database.connect(**conn_params)
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\edwardkim\Envs\shkim\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: ??? ??? ?? ? ????.\r\n")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\utils\autoreload.py", line 225, in wrapper
    fn(*args, **kwargs)
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\core\management\commands\runserver.py", line 120, in inner_run
    self.check_migrations()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\core\management\base.py", line 442, in check_migrations
    executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\migrations\executor.py", line 18, in __init__
    self.loader = MigrationLoader(self.connection)
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\migrations\loader.py", line 49, in __init__
    self.build_graph()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\migrations\loader.py", line 212, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\migrations\recorder.py", line 61, in applied_migrations
    if self.has_table():
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\migrations\recorder.py", line 44, in has_table
    return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 255, in cursor
    return self._cursor()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 232, in _cursor
    self.ensure_connection()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection
    self.connect()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection
    self.connect()
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\base\base.py", line 194, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\django\db\backends\mysql\base.py", line 227, in get_new_connection
    return Database.connect(**conn_params)
  File "C:\Users\edwardkim\Envs\shkim\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\edwardkim\Envs\shkim\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: ??? ??? ?? ? ????.\r\n")

我被这个问题困扰了这么长时间，仍然无法运行管理.py。请帮助我解决这个问题并建议我任何好的解决方案。感谢您的阅读。

Answer 1

您混淆了 MySQL 数据库和与之交互所需的 Python 库。

pip 仅安装 Python 库。要安装 MySQL 本身，您需要从其站点下载它:https://dev.mysql.com/downloads/mysql/ (或使用包管理器，例如 Chocolatey。

您需要通过pip安装的Python库是mysqlclient .