Using MySQL in R

You can use MySQL in R as follows:

> install.packages("RMySQL")
...
> library(RMySQL)
Loading required package: DBI
> connection = dbConnect(MySQL(), dbname='test')
> dbListTables(connection)
[1] "animal" "person"
>

Reference:
https://www.r-bloggers.com/accessing-mysql-through-r/