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.