Need help passing secrets contents to pymysql connector

[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