Setup MySQL connection using R in GNU linux

Ming Su

Last updated on Jun 15, 2022 1 min read

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

Install libmysqlclient-dev

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

R mysql rmysql linux database install

Ming Su

Associate Professor of Environmental Engneering

My research interest is water quality problems in drinking water bodies, with a focus on harmful algal blooms and associated taste & odor problems.