OSX系统下Python无法找到MySQLdb模块的问题求助

Hey Gil, I’ve run into this exact issue a few times—let’s walk through the most common reasons and fixes:

• Mismatched Python environments
  This is the #1 culprit. If you installed mysql-python with a global pip but you’re running a virtual environment, or you have multiple Python versions (e.g., Python 2 vs 3) installed, the module might be in a path your current Python doesn’t check.
  To verify: Run which python and which pip in your terminal. If their paths don’t line up, you’re using different environments. Fix it by activating your virtual environment first, then reinstall with python -m pip install mysql-python (using python -m pip ensures you’re using the pip tied to your current Python).

• MySQLdb isn’t in Python’s module search path
  The locate command finds files on your system, but that doesn’t mean Python knows where to look for them. Check which paths Python uses by running:

  import sys
  print(sys.path)
  

  If the path where locate MySQLdb points isn’t in this list, you can:

  • Temporarily add it in your script with sys.path.append("/path/to/MySQLdb") (not ideal for long-term use)
  • Set the PYTHONPATH environment variable to include that path
  • Reinstall the package to ensure it’s placed in a directory Python already checks

• Incomplete/corrupted installation
  Sometimes pip install finishes without obvious errors but leaves missing or broken files. First, uninstall the package cleanly:

  pip uninstall mysql-python -y
  

  Then, make sure you have the required system dependencies installed (this is often overlooked):

  • On Ubuntu/Debian: sudo apt-get install libmysqlclient-dev python-dev
  • On CentOS/RHEL: sudo yum install mysql-devel python-devel
    Now reinstall mysql-python and watch for any error messages during the install—if you see compile errors, the missing dependencies were likely the issue.

• Python 3 compatibility issues
  Heads up: mysql-python only supports Python 2. If you’re using Python 3, this package won’t work at all. Instead, install mysqlclient (a drop-in replacement that supports Python 3):

  pip install mysqlclient
  

  You’ll still be able to import it as import MySQLdb just like before. Alternatively, you can use pymysql and add this line at the start of your script to make it act like MySQLdb:

  import pymysql
  pymysql.install_as_MySQLdb()
  

内容的提问来源于stack exchange，提问作者Gil G.