Before installing the RMySQL package in R or Rstudio , there must be installed mysql-client-library in Ubuntu.
Follow the steps to work with RMySQL library in R.
Step 1 : sudo apt-get install libdbd-mysql libmysqlclient-dev
Step 2 : Rstudio -> tools -> install packages -> CRAN -> install package name : RMySQL ->install
Sign up here with your email