Hi,
I had my R to MySQL 5.0 connection working fine under 2.5.1 on Windows
XP. My MySQL installation is local, not on a server and I could connect
with:
con <- dbConnect(MySQL(), dbname = "mydatabase", user="root", password="XX")
I have updated to R 2.8.1 (RMySQL 0.7-2) but that same line of code yields:
Error in mysqlNewConnection(drv, ...) :
RS-DBI driver: (Failed to connect to database: Error: Access denied for
user 'Â $5KÅ“'@'localhost' (using password: YES)
I have tried to follow the directions in the RMySQL.pdf whereby I
created a file c:/my.cnf in which I have:
[client]
user = root
host = localhost
password=XX
database=mydatabase
And then use:
m<-dbDriver("MySQL")
con <- dbConnect(m,default.file="c:/my.cnf", group="client")
But I get:
Error in mysqlNewConnection(drv, ...) :
RS-DBI driver: (Failed to connect to database: Error: Access denied for
user 'client'@'localhost' (using password: YES)
(Note that I did also have some trouble with installation of the library
where I originally got warnings "MySQL is not installed according to a
registry search" etc so perhaps the problems are partly related to the
installation process)
Could a more savvy user than me give me some guidance?
Zev
--
Zev Ross
ZevRoss Spatial Analysis
120 N Aurora, Suite 3A
Ithaca, NY 14850
607-277-0004 (phone)
866-877-3690 (fax, toll-free)
[email protected]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
