DATA 607 Assignment 2

library(RMySQL)

## Warning: package 'RMySQL' was built under R version 3.3.2

## Loading required package: DBI

## Warning: package 'DBI' was built under R version 3.3.2

MoviesDB <- dbConnect(MySQL(),
                      user='root',
                      password=mypw,
                      dbname='Movie Ratings',
                      host='localhost')
dbListTables(MoviesDB)

## [1] "Movies"

MoviesR <- dbReadTable(MoviesDB, 'Movies')
dbDisconnect(MoviesDB)

## [1] TRUE