Spholt Spholt - 6 months ago 19
Linux Question

Installing R-Script and RMySQL on a vagrant box

I have been looking for a guide to install R-Script and (in particular) RMySQL on a laravel homestead vagrant box. However the documentation I have found has either been for windows OS's or has failed before installing the RMySQL package.

So my question is this: How do I go about installing R Script and RMySQL onto a "homestead" vagrant box?

The steps I have already followed are as follows:

> 1) vagrant up
> 2) vagrant ssh
> 3) sudo apt_get install r-base
> 4) sudo apt-get install r-base-dev
> 5) sudo apt-get update

This successfully installs R onto my vagrant box. However, when I try to install the RMySQL package as per the following article


, then i get the following error:

> -bash: syntax error near unexpected token '"RMySQL"'

I have tried with single quote, double quotes and without quotes an each time it returns an unexpected token. I have also tried running this as
but to no avail.

Once I have understood the manual process of adding these packages, I plan on automatically provisioning my vagrant box with both R and the RMySQL. Any suggestions on how this is best achieved would also be helpful. As you may be able to tell from this question, I am fairly new to server administration so any assistance would be very much appreciated.


Installing R

On a Mac:

Have Homebrew installed

brew tap homebrew/science
brew install r

Listen to your computer's fan for a while

On a Debian-like system like Vagrant boxes - (Ubuntu 14.04 here):

For installing on a Vagrant box, open a Terminal window using Vagrant Manager, then follow the instructions below.

Add the R repository to aptitude

sudo sh -c 'echo "deb http://cran.rstudio.com/bin/linux/ubuntu trusty/" >> /etc/apt/sources.list'

Add its GPG key so that you don't get cert errors

gpg --keyserver keyserver.ubuntu.com --recv-key E084DAB9
gpg -a --export E084DAB9 | sudo apt-key add -

Refresh aptitude

sudo apt-get update

Install R from new repository

sudo apt-get -y install r-base

Installing RMySQL

First install libmysqlclient

sudo apt-get install libmysqlclient-dev
sudo apt-get install r-cran-rmysql

Then Run R to enter a REPL