Hi,
I am unable to connect to MySQL.
I repeated the example in the documentation and nothing…frustration…frustration…frustration.
Thanks in advance
Can you share more details about your setup and code and what errors you are getting?
- don’t paste logs or code as images
- this is not the full log
- you probably have invalid packages in your requirements.txt file, maybe “time” which is already part of the python standard library
import streamlit as st
import pandas as pd
from sqlalchemy import create_engine
SQL_script = st.text_area(label=‘SQL Input’, value=‘SELECT * FROM df’)
@st.cache(allow_output_mutation=True)
def get_connection():
return create_engine(“mysql+pymysql://{user}:{pw}@localhost/{db}”
.format(user=“root”,
pw=“Platinum79”,
db=“ebird”))
@st.cache
def load_data(SQL_script):
with st.spinner(‘Loading Data…’):
df = pd.read_sql_query(SQL_script, get_connection())
return df
raw_data = load_data(SQL_script)
raw_data
I think the main problem is with ```
mysqlclient
