Alright, let's get that mysql.h not found error sorted out for you! This happens because MySQLdb (or its maintained fork mysqlclient) is a C-based Python extension, so it needs MySQL's development headers and libraries to compile properly. Here's how to fix it, tailored to your Windows setup first since your error log mentions Visual Studio's compiler:

Windows (Your Scenario) #

Since your error shows the Visual Studio compiler (cl.exe) is trying to build the extension, follow these steps:

• Install MySQL Connector/C
  You need the MySQL development files (which include mysql.h). Grab the MySQL Connector/C installer matching your system's architecture (32/64-bit) from MySQL's official site. When installing, select the Complete setup type, or at least check the "Development Components" option—this ensures the headers and libraries are installed.
• Point pip to MySQL files (if auto-detection fails)
  If the installer didn't add paths to your environment variables automatically, tell pip exactly where to find the headers and libraries when installing. Run this in Command Prompt (adjust paths to match your actual Connector/C installation):

  pip install mysqlclient --global-option=build_ext --global-option="-IC:\Program Files\MySQL\MySQL Connector C 8.0\include" --global-option="-LC:\Program Files\MySQL\MySQL Connector C 8.0\lib\vs14"
  

  Note: Replace 8.0 with your installed Connector/C version, and keep vs14 as-is (it matches your Visual Studio 14.0 setup).
• Switch to mysqlclient (recommended)
  MySQLdb is outdated—mysqlclient is its actively maintained fork, works with modern Python versions, and has the exact same API (no code changes needed). The command above installs this recommended replacement.

Bonus: Fixes for Other Systems #

If you or someone else runs into this on Linux/macOS, here's a quick reference:

• Debian/Ubuntu Linux

  sudo apt-get install python3-dev default-libmysqlclient-dev build-essential
  pip install mysqlclient
  

• RHEL/CentOS Linux

  sudo yum install python3-devel mysql-devel gcc
  pip install mysqlclient
  

• macOS

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

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