在 Linux (CentOS/RHEL/Fedora) 上安裝 Python MySQL 驅動,有快速安裝 (yum) 與源碼編譯兩條路。本文記錄兩種方式的步驟、常見衝突與解決方案。
sudo yum install MySQL-python # CentOS 6/7, 套件名為 MySQL-python (舊版 1.2.x)
# 或
sudo yum install python3-mysqlclient # CentOS 8+/RHEL 8+, 提供 mysqlclient 2.x
>> import MySQLdb
ImportError: this is MySQLdb version (1,2,3,'final',0), but _mysql is version (1,2,1,'final',1)
解決:刪除源碼安裝殘留檔案
rm -rf /path/to/MySQL-python-1.2.3/
# 或
pip uninstall mysqlclient MySQL-python
# 再重新 yum install
# CentOS/RHEL
sudo yum install gcc mysql-devel python3-devel
# Debian/Ubuntu
sudo apt-get install gcc libmysqlclient-dev python3-dev
wget https://bootstrap.pypa.io/ez_setup.py
sudo python ez_setup.py
wget https://files.pythonhosted.org/packages/.../mysqlclient-2.1.1.tar.gz
tar xzf mysqlclient-2.1.1.tar.gz
cd mysqlclient-2.1.1
# 確認 mysql_config 路徑
which mysql_config
# 編輯 site.cfg 指定 mysql_config
# mysql_config = /usr/bin/mysql_config
python setup.py build
sudo python setup.py install
| 錯誤 | 原因 | 解決 |
|---|---|---|
fatal error: Python.h: No such file | 缺 python-devel | yum install python3-devel |
mysql_config not found | 缺 mysql-devel 或路徑錯誤 | 安裝 mysql-devel,編輯 site.cfg 指定正確路徑 |
ssl library not found | 缺 OpenSSL 開發包 | yum install openssl-devel |
python -c "import MySQLdb; print(MySQLdb.__version__)"
# 輸出版本號即成功
pip install mysqlclient (現在 PyPI 提供 manylinux wheel,通常免編譯)。pip install PyMySQL,無系統依賴,適合容器化部署。記錄安裝過程與錯誤解法,下次部署不再踩坑。