Need help passing secrets contents to pymysql connector

[thanks_paul]

Hi folks, happy Monday. I am attempting to deploy my application which connects to a Google Cloud MySQL database. My application uses pymysql to query the database. I am not entirely sure how to pass the secrets.toml contents to the pymysql.connect() argument.

Has anyone successfully used Secrets in pymysql? Thanks so much!

[Charly_Wargnier]

Hi @thanks_paul, and welcome to the Streamlit community!

Have you tried passing your secrets variables where required in pymysql.connect()?

Maybe @BeyondMyself can help, as I believe he recently managed to deploy an app relying on pymysql, see related post here:

User authentication

import streamlit as st import pymysql import pandas as pd import webbrowser as web username=st.text_input(“Please input your username:”) pwd=st.text_input(“Please input your password”,type=‘password’) db = pymysql.connect(host=“localhost”, user=“root”, password=“abcde”, database=“python”, charset=“utf8”) sql=“select * from pwd” cursor = db.cursor() cursor.execute(sql) db.commit() df=pd.read_sql(sql,con=db) if username=="": st.info(“You do not have input user name yet”) elif pwd==""…

Charly

[BeyondMyself]

@thanks_paul @Charly_Wargnier
yes, use pymysql to connect the database is a mature solution.
see the link:

User authentication

import streamlit as st import pymysql import pandas as pd import webbrowser as web username=st.text_input(“Please input your username:”) pwd=st.text_input(“Please input your password”,type=‘password’) db = pymysql.connect(host=“localhost”, user=“root”, password=“abcde”, database=“python”, charset=“utf8”) sql=“select * from pwd” cursor = db.cursor() cursor.execute(sql) db.commit() df=pd.read_sql(sql,con=db) if username=="": st.info(“You do not have input user name yet”) elif pwd==""…

[Charly_Wargnier]

Thanks @BeyondMyself!