r - Access local mysql server with shiny.io -
I am trying to create a shiny app in shiny.io which requires access to the MySQL database, which is my local Located in the machine. Is it possible to use RMySQL to connect to local databases by shiny.io? And how can I do this?
I am a bit "late" to my answer, but keep in mind that if you are shiny Are deployed. Then the "localhost" shines Pointing to and you do not have any MySQL :-) So you have to open your MySQL server and your public IP address "host" variable is not such that I am proposing it, from the point of view of security, It is not wise to open your MySQL server publicly. If you follow this way, at least, you should only filter the connection to allow shiny.io's IP address.
Another solution - More appropriate, in my opinion - might already be using a public server, provides you with a firm layer, such as mongohq.com (now). They use MongoDB (not MySQL), but it can meet your requirements (and you will get 512 MB of RAM for test server free) You may want to study to start your project.
Comments
Post a Comment