[R] Accessing MySQL Database in R

schlafly andrewschlafly at gmail.com
Mon Jan 17 22:30:01 CET 2011

I have a local installation of MySQL on my computer.

I enter the following to access MySQL from the command line:
/Applications/MAMP/Library/bin/mysql -h localhost -u root -p
I am then prompted for a password, and I use: root
This connects me to MySQL in the command line.

I now want to access MySQL databases in R. I enter the following: 
mysql <- dbDriver("MySQL")
conn <- dbConnect(mysql,user='root',host='localhost', password='root')

I get the following error message: Error in mysqlNewConnection(drv, ...) : 
RS-DBI driver: (Failed to connect to database: Error: Access denied for user
'root'@'localhost' (using password: YES)

Does anyone know why these aren't equivalent?
View this message in context: http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221264.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list