How to connect mysql with python

dear boss see this link for free mysql db detail

this is my db detial

host = 9r-1o.h.filess.io
dbname = mfaerpdb_behaviorme
user = mfaerpdb_behaviorme
port = 3307
pwd = XXXfakepasswordXXX
db naame = mfaerpdb_behaviorme

this is connection formates
mysql://mfaerpdb_behaviorme:XXXfakepasswordXXX@9r-1o.h.filess.io:3307/mfaerpdb_behaviorme

this is mysql login command
mysql -u mfaerpdb_behaviorme -P 3307 -pXXXfakepasswordXXX -h 9r-1o.h.filess.io mfaerpdb_behaviorme

I kindly request your guidance on how to establish a connection between my database and Streamlit using Python. I have made several attempts, but I have been unsuccessful in connecting with Python. I would greatly appreciate it if you could provide me with the correct code. Thank you in advance for your assistance.

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.