A Proper way to sync ShinyApps in shiny.io with MySQL?

rstudio
dbi

#1

Hello friends, i am currently finishing my ShinyApps and like to deploy to Shiny.io for a multiple user use, but i have an issue for the deployment.

my Apps is about a Pharmacy management, it controls a CRUD operation, so clearly it is binded with db Connection using these options configuration (running this in locally)

 options(mysql = list(
    "host" = "127.0.0.1",
    "port" = 3306,
    "user" = "root",
    "password" = ""
  ))

one more thing, that i usually started my XAMPP apps and switched on mysql admin so my apps can connect the database locally. it worked flawlessly and clear before deploy

but it crashed instantly when i try to run it in the shiny.io after delpoy (what i mean is disconnected automatically). so i did try to change the host ip to publically like this , (i am trying to get ip address on user local machine)

configA <- system("ipconfig", intern=TRUE)
configB <- configA[grep("IPv4", configA)]
configC <- gsub(".*? ([[:digit:]])", "\\1", configB)
  
  options(mysql = list(
    "host" = configC,
    "port" = 3306,
    "user" = "root",
    "password" = ""
  ))

but it didn't affect the crash.. can anyone help me give some appointment of a proper way to do these?


#2

below is my Shiny.io logs
https://www.writeurl.com/text/5q57len9epxh3aur2pt0/ymeqffrqkb40za4cw3zt/5kn5yj3srz9nzrdvrlu4


#3

here is my Shiny.io Logs
https://www.writeurl.com/text/5q57len9epxh3aur2pt0/ymeqffrqkb40za4cw3zt/5kn5yj3srz9nzrdvrlu4