How to add shinyapp.io to my GCP SQL networks

Posit Professional & Hosted Products shinyapps.io
1

I have written a shiny app that I am hosting on the free shinyapp.io servers. The App has a MySQL database that I hosted on Google Cloud Platform SQL. I have already added my local address IP to the list of networks and that allows the App to connect to the database when running on my lap. But when deploying it on the Shiny App servers it doesn't connect. Do you have any suggestions?

Here is my connection logic:

ch <- dbConnect(MySQL(),user='root',password='***************',
                host = '**.***.***.***', dbname = 'mydatabase')
2

Whitelist shinyapps.io's ip address

1 Like
3

Thanks a lot, that was very helpful.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.