Agar python bisa terhubung dengan database MySQL, maka perlu ada library yang namanya mysqlclient. Nah, terkadang pada waktu kita install muncul error seperti dibawah ini.

((siabsen:3.11)) [besutodi@safir siabsen]$ pip install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-2.2.4.tar.gz (90 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Installing backend dependencies ... done
Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: mysqlclient
Building wheel for mysqlclient (pyproject.toml) ... error
error: subprocess-exited-with-error

× Building wheel for mysqlclient (pyproject.toml) did not run successfully.
│ exit code: 1
╰─> [47 lines of output]
building 'MySQLdb._mysql' extension
creating build/temp.linux-x86_64-cpython-311
creating build/temp.linux-x86_64-cpython-311/src
creating build/temp.linux-x86_64-cpython-311/src/MySQLdb
gcc -DDYNAMIC_ANNOTATIONS_ENABLED=1 -DNDEBUG -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -D_GNU_SOURCE -fPIC -fwrapv -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -fPIC "-Dversion_info=(2, 2, 4, 'final', 0)" -D__version__=2.2.4 -I/home/besutodi/virtualenv/siabsen/3.11/include -I/opt/alt/python311/include/python3.11 -c src/MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-311/src/MySQLdb/_mysql.o -I/usr/include/mysql -std=c99
src/MySQLdb/_mysql.c:47:10: fatal error: Python.h: No such file or directory
#include "Python.h"
^~~~~~~~~~
compilation terminated.
error: command '/bin/gcc' failed with exit code 1
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
ERROR: Failed building wheel for mysqlclient
Failed to build mysqlclient
ERROR: Could not build wheels for mysqlclient, which is required to install pyproject.toml-based projects

Contoh diatas menggunakan Python versi 3.11 

Ketika kita mencoba install : pip install mysqlclient , hasilnya error tersebut. Hal ini karena ada library python311 yang kurang.

Tentunya kamu harus kontak provider hosting yang memegang akses root server. Dalam kasus ini, kami berhasil menyelesaikan dengan cara install library alt-python311-devel.

yum install alt-python311-devel

Setelah sukses, maka kamu bisa lanjut dengan install mysqlclient dari terminal user tersebut ya.

((siabsen:3.11)) [besutodi@safir siabsen]$ pip install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-2.2.4.tar.gz (90 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Installing backend dependencies ... done
Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: mysqlclient
Building wheel for mysqlclient (pyproject.toml) ... done
Created wheel for mysqlclient: filename=mysqlclient-2.2.4-cp311-cp311-linux_x86_64.whl size=136641 sha256=d75ae0f80050adeb47b1b413de38b09802354d990e636a86c7768fc69e17aace
Stored in directory: /home/besutodi/.cache/pip/wheels/1e/2f/4c/0bd8be7e2f3255f9436ce68bb1c2563661e8b7bbd49dcff0e0
Successfully built mysqlclient
Installing collected packages: mysqlclient
Successfully installed mysqlclient-2.2.4

Untuk memastikan benar sudah ter-install, kamu bisa list semua library menggunakan perintah pip.

((siabsen:3.11)) [besutodi@safir siabsen]$ pip list
Package Version
--------------- -------
asgiref 3.7.2
Django 5.0.1
et-xmlfile 1.1.0
mysqlclient 2.2.4
numpy 1.26.3
openpyxl 3.1.2
pandas 2.2.0
pillow 10.2.0
pip 24.0
python-dateutil 2.8.2
pytz 2024.1
setuptools 69.0.2
six 1.16.0
sqlparse 0.4.4
tzdata 2023.4
wheel 0.41.3

Kesimpulan

Biasanya dengan missing library mysqlclient, website akan memunculkan error 500. Dimana kamu bisa cek error_log di direktory dimana python tersebut di install dengan nama file sttdr.log

Dari sana kamu bisa identifikasi apa penyebab error nya, jika mirip dengan contoh diatas, kemungkinan besar memang ada missing library alt-pythonXX-devel

Mudah bukan menyelesaikan problem mysqlclient yang gagal ter-install. Semoga artikel ini bermanfaat ya !