MacOS 14系统下无法安装mysqlclient的问题求助

问题重现 #

执行pip install mysqlclient时遇到头文件缺失错误：

In file included from src/MySQLdb/_mysql.c:29:
/opt/homebrew/Cellar/mysql/8.3.0_1/include/mysql/mysql.h:46:10: fatal error: 'sys/types.h' file not found
#include <sys/types.h>
         ^~~~~~~~~~~~~

设置CFLAGS环境变量后出现架构兼容错误：

error: unable to create target: 'No available targets are compatible with triple "x86_64-apple-macosx10.9.0"'
1 error generated.

解决方案 #

1. 确保Command Line Tools和SDK正常 #

先检查并安装最新的Command Line Tools：

xcode-select --install
sudo xcode-select -s /Library/Developer/CommandLineTools

查看当前可用的SDK版本，替换后续命令中的版本号：

ls /Library/Developer/CommandLineTools/SDKs/

示例输出：MacOSX14.4.sdk

2. 针对Apple Silicon（M系列芯片）的原生Python #

设置正确的编译参数后直接安装：

export CFLAGS="-isysroot /Library/Developer/CommandLineTools/SDKs/MacOSX14.4.sdk -I/Library/Developer/CommandLineTools/SDKs/MacOSX14.4.sdk/usr/include -mmacosx-version-min=14.4"
export LDFLAGS="-L/opt/homebrew/lib"
pip install mysqlclient

3. 针对x86_64版本的Python（Rosetta运行） #

切换到x86_64环境，指定对应架构的编译参数：

arch -x86_64 zsh
export CFLAGS="-isysroot /Library/Developer/CommandLineTools/SDKs/MacOSX14.4.sdk -I/Library/Developer/CommandLineTools/SDKs/MacOSX14.4.sdk/usr/include -mmacosx-version-min=14.4"
export LDFLAGS="-L/usr/local/lib"
pip install mysqlclient

4. 备选方案：通过Homebrew预安装依赖 #

先通过Homebrew安装mysqlclient依赖，再让Pip链接：

brew install mysqlclient
echo 'export PATH="/opt/homebrew/opt/mysqlclient/bin:$PATH"' >> ~/.zshrc
export LDFLAGS="-L/opt/homebrew/opt/mysqlclient/lib"
export CPPFLAGS="-I/opt/homebrew/opt/mysqlclient/include"
pip install mysqlclient

原因说明 #

• 头文件缺失错误：编译器无法定位系统核心头文件，需明确指定SDK路径。
• 架构兼容错误：编译目标的macOS版本与当前系统不匹配，或Python/MySQL架构不一致，需统一架构并指定对应系统版本的编译参数。

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