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 …

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.

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

Franky1 September 8, 2023, 10:51am 16

Topic		Replies	Views
Mysqlclient causes Error installing requirements, can't deploy app Community Cloud streamlit-cloud , mysql , debugging	2	662	August 13, 2024
Never works! Add dependencies to your requirements file Add the mysqlclient and SQLAlchemy packages to your requirements.txt file, Community Cloud streamlit-cloud , debugging	4	153	November 5, 2024
Streamlit cloud face issue in mysqlclient installing Community Cloud	1	2168	March 16, 2022
Deploying error when deploy to streamlit cloud Community Cloud	2	960	September 19, 2023
I dont know why failed when deploy and when install mysql Community Cloud mysql	2	896	August 24, 2023

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

Related topics