Mariadb developement

[rvandam]

I did a fresh Directadmin install on Almalinux 9 yesterday. I need the Mariadb development files for installing python mysqlclient.

On a previous installation Mariadb was installed through the package manager and I could add mariadb-devel. Now it looks like Mariadb is installed by custombuild. How do I install the devel libs?

The error from a pip install:

Exception: Can not find valid pkg-config name.
Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually

Error from yum trying the global python3-mysqlclient package:

Problem: package python3-mysqlclient-2.1.0-1.el9.x86_64 from epel requires libmariadb.so.3()(64bit), but none of the providers can be installed

 

[rvandam]

I found the solution mentioned here:
https://stackoverflow.com/questions...via-pip-cannot-find-pkg-config-name-in-ubuntu

MYSQLCLIENT_CFLAGS="-I/usr/local/mariadb-10.6.19-hoDP/include/mysql" MYSQLCLIENT_LDFLAGS="-L/usr/local/mariadb-10.6.19-hoDP/lib -lmysqlclient" pip3 install mysqlclient