Aim

To connect mysql database using R is very important if you want to do some data analysis, I have extreamly bad experience on setting up it in GNU/linux, as I know, it is not easy to setup in windows as well.

Install

sudo apt-get install libmysqlclient-dev

wget http://cran.r-project.org/src/contrib/RMySQL_0.9-3.tar.gz
R CMD INSTALL --configure-args='--with-mysql-dir=/usr/lib' RMySQL_0.9-3.tar.gz