Deploying on streamlit - Connection error with Database

[krish]

Hi there, I have deployed an app on streamlit app. But it shows an error with connecting to database [I used mysql workbench]. It executed well on local machine. But gives an error while deploying. Please let me know if you have any solutions.

Error:
pymysql.err.OperationalError: (2003, “Can’t connect to MySQL server on ‘localhost’ ([Errno 99] Cannot assign requested address)”)

[Franky1]

pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Cannot assign requested address)")

Hello, I am facing an issue with my Streamlit application when connecting to my local MySQL database. Here are the details of the error: [22:41:36.439] Uncaught app exception Traceback (most recent call last): File "/home/appuser/venv/lib/python3.9/site-packages/pymysql/connections.py", line 644, in connect sock = socket.create_connection( File "/usr/local/lib/python3.9/socket.py", line 844, in create_connection raise err File "/usr/local/lib/python3.9/socket.py", line 832, i…