MySQL Database Access in R via RMySQL

Requirements

Installation

install.packages("DBI")
install.packages("RMySQL")

Usage

library(DBI)
library(RMySQL)
dbConnect(RMySQL::MySQL(), username="$USERNAME", password="$PASSWORD", dbname="$DATABASENAME")

Now that we have our connection, we can use the standard DBI functions.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.