Need help passing secrets contents to pymysql connector

[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==""…