When deploying my app, I get this error while trying to install mysqlclient: Exception: Can not find valid pkg-config name. Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually I don’t want to have to set these vars manually but would prefer to install pkg-config on my Windows com…

Not getting much love here. Is there anyone who can help me resolve this?

Hi @Daniel_Attard In setting the path, there are ways to do this graphically ( How to Set the Path and Environment Variables in Windows ) or in the command line ( set | Microsoft Learn ) via set As for the environment variable name, not sure if PATH is the only environment variable that it may refer t…

When I check the PATH variable, by entering echo %PATH% I can see that the location of my pkg-config.exe file which is located in C:\msys64\mingw64\bin as seen here: [pkg-config] But I still keep getting the same error saying pkg-config: not found as seen here: [mysqlclient] I see a referenc…

Hi @Daniel_Attard Looking at the README page of mysqlclient ( https://github.com/PyMySQL/mysqlclient/blob/main/README.md ) indicated that you’ll need to have the DB connector installed in addition to mysqlclient. Please see if you can either download a binary version for use as building one seems to …

Thanks for your ideas Chanin. I was able to download the MariaDB C Connector and install it, but that didn’t seem to make any difference as I still get the same errors with the mysqlclient install failing because pkg-config not found. I then decided to try your suggestion of using Miniconda3. I wa…

Hi @Daniel_Attard Thanks for the update and sounds like we’re making some progress. It seems from the screenshot that you’re using Python 3.7 and starting from Streamlit 1.24.0 it requires at least 3.8 as 3.7 is no longer supported. Also have you tried following the tutorial on setting up a MySQL c…

Hi again. Unfortunately I am still stuck. I created a new virtual environment and it still gives me the same error when trying to install mysqlclient. This is all very frustrating because everything works fine under localhost, but fails when prtocessing the dependencies during deployment. Here is …

One final update for anyone following along. I managed to resolve this issue by switching from mysqlclient to pymysql in the requirements.txt file. I also added this line to my connections credential information: driver = "pymysql" as shown here: [connections.CloudSQL] dialect = "mysql" driver = …

Problem installing mysqlclient - Can not find valid pkg-config name

Community Cloud

dataprofessor July 18, 2023, 11:51am 9

Hi @Daniel_Attard

Sorry to hear that it is still not working. Would you like to share the code repo to your app. This is the best way to allow the reproduction of the error.

Topic		Replies	Views
Mysqlclient causes Error installing requirements, can't deploy app Community Cloud streamlit-cloud , mysql , debugging	3	600	February 9, 2025
Never works! Add dependencies to your requirements file Add the mysqlclient and SQLAlchemy packages to your requirements.txt file, Community Cloud streamlit-cloud , debugging	5	129	November 5, 2024
Streamlit cloud face issue in mysqlclient installing Community Cloud	2	2151	March 16, 2023
Deploying error when deploy to streamlit cloud Community Cloud	3	883	March 17, 2024
I dont know why failed when deploy and when install mysql Community Cloud mysql	3	877	August 24, 2023

Problem installing mysqlclient - Can not find valid pkg-config name

Related topics