How to add to my GCP SQL networks

I have written a shiny app that I am hosting on the free 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')

Whitelist's ip address

1 Like

Thanks a lot, that was very helpful.

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.