Skip to content

Instantly share code, notes, and snippets.

@glw
Last active August 29, 2015 14:02
Show Gist options
  • Save glw/a9c1cace06203f297461 to your computer and use it in GitHub Desktop.
Save glw/a9c1cace06203f297461 to your computer and use it in GitHub Desktop.
RMySQL Install
#Ubuntu 12.04
#R 3.1.0
terminal:
sudo apt-get install libdbd-mysql libmysqlclient-dev
wget http://cran.r-project.org/src/contrib/RMySQL_0.9-3.tar.gz
sudo R CMD INSTALL --configure-args='--with-mysql-inc=/usr/include/mysql' --configure-args='--with-mysql-lib=/usr/lib64/mysql' /home/user/Downloads/RMySQL_0.9-3.tar.gz
sudo apt-get install r-cran-rmysql
sudo apt-get install r-cran-dbi
# In Rstudio:
library(RMySQL)
Loading required package: DBI ## <- Successful installation
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment