I have developed a shiny app and connected it with MySQL database which is running on my local computer. the app is working smoothly when I am accessing it locally. But when I deployed the app on shinyapps.io it is unable to connect with the SQL database.
I know this is not a new question and there are several articles on it but somehow they were unable to help me.
Till now I have done the following (suggested in the articles):-
- Changed the bind address in the my.ini file to 0.0.0.0
- Change the firewall settings and allowed a new inbound rule to allow from port 3306.
What else do I need to change to make it work??