Django连接MySQL时pip install mysqlclient报错求助

Hey there, let's work through this tricky mysqlclient compilation issue you're hitting—after sorting out the Visual C++ and vcvarsall.bat hurdles, the missing mysql.h header is the next roadblock. Here's how to fix it step by step:

• First, install MySQL's development libraries
  The mysql.h file isn't included with a standard MySQL Server installation—it's part of the MySQL developer components. If you're on Windows:

  1. Download the official MySQL Installer.
  2. Run it, and make sure to select either "MySQL Connector/C" or the full "Developer Components" package during installation.
  3. Note down the installation paths afterward: you'll need the include folder (usually C:\Program Files\MySQL\MySQL Server 8.0\include) and lib folder (like C:\Program Files\MySQL\MySQL Server 8.0\lib\opt).

• Tell pip where to find MySQL's headers and libraries
  Open a command prompt (run as administrator) and set these environment variables before installing mysqlclient, replacing the paths with your actual MySQL install locations:

  set MYSQLCLIENT_CFLAGS="-IC:\Program Files\MySQL\MySQL Server 8.0\include"
  set MYSQLCLIENT_LDFLAGS="-LC:\Program Files\MySQL\MySQL Server 8.0\lib\opt"
  pip install mysqlclient
  

  Double-check that the paths match your system (e.g., use Program Files (x86) if you installed 32-bit MySQL).

• Skip compilation entirely with pre-built wheels
  If compiling feels too messy, you can grab a pre-compiled mysqlclient wheel from unofficial Python package binaries. Just:

  1. Download the .whl file that matches your Python version and system architecture (e.g., mysqlclient-2.2.0-cp310-cp310-win_amd64.whl for Python 3.10 64-bit).
  2. Install it directly with pip:

     pip install path/to/your/mysqlclient-file.whl
     

• Double-check your Visual Studio setup
  Since you modified the msvc9compiler file earlier, ensure you're using the right Visual C++ toolset for your Python version:

  • Python 3.8+ requires Visual Studio 2019 or 2022 Build Tools.
  • Make sure you've installed the "Desktop development with C++" workload in Visual Studio Build Tools, including the appropriate Windows SDK.

• Verify your Django connection
  Once mysqlclient installs successfully, update your Django settings.py with the MySQL database config:

  DATABASES = {
      'default': {
          'ENGINE': 'django.db.backends.mysql',
          'NAME': 'your_database_name',
          'USER': 'mysql_username',
          'PASSWORD': 'your_mysql_password',
          'HOST': '127.0.0.1',
          'PORT': '3306',
      }
  }
  

  Test the connection with python manage.py migrate—it should run without errors if everything's set up right.

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