Linux VM + MySQL + R + DBI

• Linux VM 
• get it @c9.io

• MySQL
• type mysql on c9.io terminal and you'll have mysql server access

• R
• if old version is sufficient (note, DBI requires >= 2.51), run
• c9pm install r-lang
• or, manual install for newer version (take quite a while...), see:
• http://stackoverflow.com/questions/13146852/r-2-15-install-in-redhat
• http://cran.r-project.org/doc/manuals/r-release/R-admin.html#Installing-R-under-Unix_002dalikes

• DBI
• from R, install.packages('DBI')
• RMySQL
• wget 'http://cran.r-project.org/src/contrib/RMySQL_0.9-3.tar.gz'
• R CMD INSTALL RMySQL_0.9-3.tar.gz 

Try it from R:

> library(DBI)

> library(RMySQL)

> con <- dbConnect(MySQL(), user="USER", dbname="DB", host="HOSTNAME")

> dbGetQuery(con, "select curdate() from dual;")

   curdate()

1 2014-01-03