the question basically is:
Is there any way for an app shared by the https://share.streamlit.io/ platform to access a Mysql DB that is on a linux server within an organization?
The idea would be to guarantee that external accesses (outside the organization) would not be able to access the mysql DB (it would display an error message when connecting the DB).
If this is impossible and if you have any alternative, it will be very welcome.
I have a mysql database on my linux server. This server is limited by the company’s intranet network.
I created an app.py that should access this database and hosted it at https://share.streamlit.io .
Problem: I can’t get app.py to establish a connection to mysql which is on the linux server.
IP host, database name, username and password entered correctly (in the pymysql session).
Could the problem just be a server-side firewall rule?
Or simply the https://share.streamlit.io platform that does not accept this type of external connection with mysql?
Any such limitation can interfere your ability to connect to the DB from the deployed application. You might need to clear this with your DB / network admins.