dear boss
I have included my code along with the hosting details in the attached image; however, I am encountering an error indicating that it is unable to connect to the Streamlit application.
see error
mysql.connector.errors.InterfaceError: 2003: Can’t connect to MySQL server on ‘sql311.infinityfree.com:3306’ (11001 getaddrinfo failed)
import mysql.connector
import streamlit as st
import pandas as pd
mydb = mysql.connector.connect(
host=“sql311.infinityfree.com”,
user=“if0_38494553”,
password="******** ",
database=“if0_38494553_mfaerp”,
port=3306 )
curr = mydb.cursor()
curr.execute(“select * from persons”)
data = curr.fetchall()
df = pd.DataFrame(data,columns=curr.column_names)
st.write(df)
my hostting detial
error picture