Connect brilliant application to mysql database on server

Question

can someone help on how t mount brilliant mysql database on server. I can connect locally on my system, but how can we do the same on the server to make it available over the Internet.

Answer 1

Install the package below from the console R

install.packages ("RMySQL", dependencies = TRUE)

And you can use mysql database as below:

Code inside server.R :

library(RMySQL) options(mysql = list( "host" = "127.0.0.1", "port" = 3306, "user" = "myuser", "password" = "mypassword" )) databaseName <- "DATABASE NAME" table <- "TABLE" 

We hope this helps you connect your application to the mysql database. If you still need help let me know :)