App publish to Shinyappsio can not connect MySQL

Well, this is most likely a problem with your MySQL security settings, are you sure this is a reachable public IP accepting connections on port 3306? Have you checked firewall rules in your server allow for incoming traffic from remote locations?