MacOS系统下无法安装mysql-python及MYSQLdb的技术求助

Hey there, let's work through this MySQL-python/MySQLdb installation mess you're dealing with—this is a super common pain point, so I’ve got a few tried-and-true fixes to share:

1. First, nail down the system dependencies you’re missing #

9 times out of 10, these installation errors boil down to missing MySQL development libraries. Here’s how to install them based on your OS:

• Ubuntu/Debian: Run sudo apt-get install python-dev default-libmysqlclient-dev
• CentOS/RHEL: Use sudo yum install python-devel mysql-devel
• Windows: Skip the source code route entirely—you’ll need Visual C++ Build Tools for compilation, which is way more hassle than it’s worth. Stick to pre-built packages instead (see step 2).

2. Ditch the problematic source install for a pre-built wheel #

MySQL-python is pretty outdated, and compiling from source is prone to issues. Instead, use mysqlclient—it’s a maintained fork that’s fully compatible with MySQLdb and way easier to install:

pip install mysqlclient

If you must stick with the original MySQL-python (only recommended for Python 2), try forcing pip to use a pre-built wheel instead of compiling from source:

pip install mysql-python==1.2.5 --only-binary :all:

3. If you absolutely need to use the source code #

If you’re set on using the SourceForge code, make sure you point the setup script to your mysql_config executable (this is often the missing piece). First, find where mysql_config lives on your system (common paths are /usr/bin/mysql_config or /usr/local/mysql/bin/mysql_config), then run:

python setup.py install --mysql-config=/path/to/your/mysql_config

Bonus: For Python 3 users #

MySQL-python doesn’t support Python 3 at all. If you’re on Python 3, use mysqlclient (from step 2) or pymysql as a drop-in replacement:

pip install pymysql

Then add this line at the top of your Python code to make it act like MySQLdb:

import pymysql
pymysql.install_as_MySQLdb()

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