RMySQL, Shiny and PHP cloud

Question

I'm trying to develop R shiny application using MySQL database. I'm trying to use PHP cloud and its MySQL database. And my Shiny application is in shiny cloud environment. I'm deploying my application using R Studio. So how I can connect RMySQL to MySQL database in the PHP cloud using R Studio. I tried installing RMySQL in R Studio but it gives me this error.

Warning: running command 'sh ./configure.win' had status 1
ERROR: configuration failed for package 'RMySQL'

Macilroy

There is a nice tutorial on installing RMySQL under Windows. Maybe it will help. – Mcdaniels

Looks like exact duplicate of https://mcmap.net/q/1501906/-error-installing-rmysql/2157640, but it has no answers either. – Mcdaniels

Actually I did install RMySQL in my computer. But my problem is how I'm going to connect it to cloud environment? – Macilroy