MacOS下无法安装flask-mysqldb的问题求助

问题描述 #

安装flask-mysqldb时，因mysqlclient编译依赖缺失触发如下链接错误：

ld: library not found for -lzlib
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command '/usr/bin/clang' failed with exit code 1

已配置以下环境变量，但问题未解决：

export LDFLAGS="-L/opt/homebrew/opt/mysql-client/lib"
export CPPFLAGS="-I/opt/homebrew/opt/mysql-client/include"
export PKG_CONFIG_PATH="/opt/homebrew/opt/mysql-client/lib/pkgconfig"
export PATH="/usr/local/opt/mysql-client/bin:$PATH"

export LDFLAGS="-L/opt/homebrew/opt/zlib/lib"
export CPPFLAGS="-I/opt/homebrew/opt/zlib/include"
export PKG_CONFIG_PATH="/opt/homebrew/opt/zlib/lib/pkgconfig"
export DYLD_LIBRARY_PATH=/opt/homebrew/Cellar/zlib/lib:$DYLD_LIBRARY_PATH

可行解决方案 #

• 合并环境变量而非覆盖
  当前环境变量设置为覆盖式（第二次设置LDFLAGS会替换第一次的mysql-client路径），需将mysql-client和zlib的路径合并：

  export LDFLAGS="-L/opt/homebrew/opt/mysql-client/lib -L/opt/homebrew/opt/zlib/lib"
  export CPPFLAGS="-I/opt/homebrew/opt/mysql-client/include -I/opt/homebrew/opt/zlib/include"
  export PKG_CONFIG_PATH="/opt/homebrew/opt/mysql-client/lib/pkgconfig:/opt/homebrew/opt/zlib/lib/pkgconfig"
  export PATH="/usr/local/opt/mysql-client/bin:$PATH"
  export DYLD_LIBRARY_PATH="/opt/homebrew/Cellar/zlib/lib:/opt/homebrew/opt/mysql-client/lib:$DYLD_LIBRARY_PATH"
  

  设置完成后，重新打开终端或执行source ~/.zshrc（或~/.bashrc）使配置生效，再尝试安装。

• 直接安装预编译的mysqlclient
  若编译问题持续，可通过Homebrew安装预编译的mysqlclient，再安装flask-mysqldb：

  brew install mysqlclient
  pip install flask-mysqldb
  

• 检查zlib实际安装路径
  确认zlib的安装路径是否正确，执行以下命令查看：

  brew list zlib
  

  若输出路径与环境变量中的/opt/homebrew/opt/zlib不符，需替换为实际路径。

• 强制指定链接库参数
  尝试在安装时直接指定zlib的链接参数，绕过名称识别问题：

  LDFLAGS="-lz -L/opt/homebrew/opt/zlib/lib" CPPFLAGS="-I/opt/homebrew/opt/zlib/include" pip install flask-mysqldb
  

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