Python 3.9环境下无法安装mysqlclient的问题求助
问题重现
执行命令:
pip3 install mysqlclient
触发如下错误:
x86_64-linux-gnu-gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O2 -Wall -g -fstack-protector-strong -Wformat -Werror=format-security -g -fwrapv -O2 -fPIC -Dversion_info=(2,1,1,'final',0) -D__version__=2.1.1 -I/usr/include/mysql -I/home/eweinsh/microservice/src/auth/_venv/include -I/usr/include/python3.9 -c MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-39/MySQLdb/_mysql.o -std=c99
MySQLdb/_mysql.c:46:10: fatal error: Python.h: No such file or directory
46 | #include "Python.h"
| ^~~~~~~~~~
compilation terminated.
error: command '/usr/bin/x86_64-linux-gnu-gcc' failed with exit code 1note: This error originates from a subprocess, and is likely not a problem with pip.
error: legacy-install-failure
系统环境:Python 3.9,运行于WSL中的Ubuntu 20.04。已尝试重装带推荐包的Python3、添加MySQL配置文件,问题仍未解决。
解决方案
错误核心是缺少编译Python扩展所需的Python.h头文件,同时mysqlclient编译依赖MySQL开发库,按以下步骤操作:
- 安装Python3.9的开发依赖包:
sudo apt-get update && sudo apt-get install python3.9-dev
- 安装MySQL开发依赖库:
sudo apt-get install default-libmysqlclient-dev
- 重新执行mysqlclient安装命令:
pip3 install mysqlclient
说明
python3.9-dev包包含Python.h等编译Python扩展必需的头文件,Ubuntu默认安装Python时不会自动附带该包。default-libmysqlclient-dev提供mysqlclient编译所需的MySQL头文件与库文件,确保编译流程能找到相关资源。
内容的提问来源于stack exchange,提问作者wishfulwiz

