VS中创建venv安装mysqlclient遇mysql.h缺失，已试方案仍无效

我在Visual Studio中创建venv虚拟环境时遇到异常，尽管已安装所有所需组件，核心错误是安装mysqlclient时找不到mysql.h文件，错误日志如下：

2023-05-12 14:26:14.216 [info]  copying MySQLdb\constants\CLIENT.py -> build\lib.win32-cpython-38\MySQLdb\constants
      copying MySQLdb\constants\CR.py -> build\lib.win32-cpython-38\MySQLdb\constants
      copying MySQLdb\constants\ER.py -> build\lib.win32-cpython-38\MySQLdb\constants
      copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win32-cpython-38\MySQLdb\constants
      copying MySQLdb\constants\FLAG.py -> build\lib.win32-cpython-38\MySQLdb\constants
      running build_ext
      building 'MySQLdb._mysql' extension
      creating build\temp.win32-cpython-38
  
2023-05-12 14:26:14.217 [info]     creating build\temp.win32-cpython-38\Release
      creating build\temp.win32-cpython-38\Release\MySQLdb
      "C:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\MSVC\14.35.32215\bin\HostX86\x86\cl.exe" /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Dversion_info=(2,1,1,'final',0) -D__version__=2.1.1 "-IC:\Program Files (x86)\MariaDB\MariaDB Connector C\include\mariadb" "-IC:\Program Files (x86)\MariaDB\MariaDB Connector C\include" "-Ic:\Users\swagw\Documents\PROJECT FOR SOFTWARE ENGINEERING\.venv\include" -IC:\Users\swagw\AppData\Local\Programs\Python\Python38-32\include -IC:\Users\swagw\AppData\Local\Programs\Python\Python38-32\Include "-IC:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\MSVC\14.35.32215\include" "-IC:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\MSVC\14.35.32215\ATLMFC\include" "-IC:\Program Files\Microsoft Visual Studio\2022\Community\VC\Auxiliary\VS\include" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22000.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22000.0\\um" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22000.0\\shared" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22000.0\\winrt" "-IC:\Program Files (x86)\Windows Kits\10\\include\10.0.22000.0\\cppwinrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\include\um" /TcMySQLdb/_mysql.c /Fobuild\temp.win32-cpython-38\Release\MySQLdb/_mysql.obj
      _mysql.c
      MySQLdb/_mysql.c(29): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
      error: command 'C:\\Program Files\\Microsoft Visual Studio\\2022\\Community\\VC\\Tools\\MSVC\\14.35.32215\\bin\\HostX86\\x86\\cl.exe' failed with exit code 2
2023-05-12 14:26:14.217 [info] 
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.

2023-05-12 14:26:14.218 [info]   ERROR: Failed building wheel for mysqlclient

2023-05-12 14:26:14.218 [info] Failed to build mysqlclient

2023-05-12 14:26:14.219 [info] ERROR: Could not build wheels for mysqlclient, which is required to install pyproject.toml-based projects

2023-05-12 14:26:14.399 [info] Traceback (most recent call last):
  File "c:\Users\swagw\.vscode\extensions\ms-python.python-2023.8.0\pythonFiles\create_venv.py", line 77, in run_process

2023-05-12 14:26:14.399 [info]     subprocess.run(args, cwd=os.getcwd(), check=True)
  File "C:\Users\swagw\AppData\Local\Programs\Python\Python38-32\lib\subprocess.py", line 512, in run

2023-05-12 14:26:14.399 [info]     raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError
2023-05-12 14:26:14.399 [info] : Command '['c:\\Users\\swagw\\Documents\\PROJECT FOR SOFTWARE ENGINEERING\\.venv\\Scripts\\python.exe', '-m', 'pip', 'install', '-r', 'c:\\Users\\swagw\\Documents\\PROJECT FOR SOFTWARE ENGINEERING\\requirements.txt']' returned non-zero exit status 1.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:\Users\swagw\.vscode\extensions\ms-python.python-2023.8.0\pythonFiles\create_venv.py", line 232, in <module>

2023-05-12 14:26:14.399 [info]     main(sys.argv[1:])
  File "c:\Users\swagw\.vscode\extensions\ms-python.python-2023.8.0\pythonFiles\create_venv.py", line 228, in main

2023-05-12 14:26:14.400 [info]     install_requirements(venv_path, args.requirements)
  File "c:\Users\swagw\.vscode\extensions\ms-python.python-2023.8.0\pythonFiles\create_venv.py", line 97, in install_requirements

2023-05-12 14:26:14.400 [info]     run_process(
  File "c:\Users\swagw\.vscode\extensions\ms-python.python-2023.8.0\pythonFiles\create_venv.py", line 79, in run_process
    raise VenvError(error_message)

2023-05-12 14:26:14.400 [info] __main__.VenvError: CREATE_VENV.PIP_FAILED_INSTALL_REQUIREMENTS

2023-05-12 14:26:14.407 [error] Error while running venv creation script:  CREATE_VENV.PIP_FAILED_INSTALL_REQUIREMENTS
2023-05-12 14:26:14.407 [error] CREATE_VENV.PIP_FAILED_INSTALL_REQUIREMENTS

我试过针对该问题的常见解决方案，但仍然报错，请求帮助。

内容的提问来源于stack exchange，提问作者bob hope