[R] Accessing MySQL Database in R
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