Error in library RMySQL there is no package called RMySQL

Question

Hi Guys,

I have one MySQL server in the Linux system. I want to connect the server with R. But I am not able to use RMySQL library.

$ library("RMySQL")
Error in library("RMySQL") : there is no package called ‘RMySQL’

Answer 1

Hi@akhtar,

R has a built-in package named "RMySQL" which provides native connectivity between with MySql database. You can install this package in the R environment using the following command.

$ install.packages("RMySQL")