Setup MySQL connection using R in GNU linux
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.
sudo apt-get install libmysqlclient-dev
download and install RMySQL
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