导入openpyxl时出现WinError 5权限拒绝问题求助

执行import openpyxl代码时触发报错，完整报错栈如下：

Traceback (most recent call last):
  File "D:\Py\test.py", line 3, in <module>
    import openpyxl
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\__init__.py", line 6, in <module>
    from openpyxl.workbook import Workbook
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\workbook\__init__.py", line 4, in <module>
    from .workbook import Workbook
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\workbook\workbook.py", line 17, in <module>
    from openpyxl.writer.excel import save_workbook
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\writer\excel.py", line 31, in <module>
    from openpyxl.packaging.manifest import Manifest
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\packaging\manifest.py", line 42, in <module>
    mimetypes = MimeTypes()
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\mimetypes.py", line 74, in __init__
    init()
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\mimetypes.py", line 368, in init
    db.read_windows_registry()
  File "C:\Users\[my_username]\AppData\Local\Programs\Python\Python310\lib\mimetypes.py", line 253, in read_windows_registry
_mimetypes_read_windows_registry(add_type)

最终报错为PermissionError: [WinError 5] Access is denied。

已尝试以下方案但均无效：

• 升级pip
• 获取AppData\Local\Programs\Python目录所有权
• 安装pydirectory
• 以管理员身份运行文件
• 通过管理员CMD运行文件
• 卸载并重装openpyxl

目前仅找到半解决方案：将Python从3.10.8降级到3.7可消除报错，但Python 3.8及以上版本均会触发该问题，不清楚具体原因，寻求彻底解决办法。

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