I have deployed a shiny app on shinyapp.io server. This app is connected with a MySQL database. So when I was working locally, I have connected the db like below -
mydb <- dbConnect(MySQL(), user = 'root', password = '', dbname = 'test', port = 3306)
But I do not know how to connect the database when the app is live on the server.
Can anyone help me with this issue? How can I connect MySQL database with live app?
Thanks in advance.