i have recently same problems, but when i add a new user without
password it works, but i could
not recognize why the user with password didn't work. After a new mysql (Win-XP mysqll 5.0.13 rc )
installation it works normal.
DBI version 0.1-9
arch i386 os mingw32 system i386, mingw32 status Patched major 2 minor 1.1 year 2005 month 09 day 07 language R
>I get the following error trying to connect to a MySQL database:
> > library(RMySQL)
>Loading required package: DBI
> > drv<-dbDriver("MySQL")
> > con<-dbConnect(drv, user="hothand", password=xxx,
>Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not
>connect hothand@localhost on dbname "hh03"
>This script worked a few days ago, and I haven't made any system
>changes since then. I can connect to mysql from php and the mysql
>console. I've also reinstalled the DBI and RMySQL packages, to no avail.
>Thanks in advance.
> > version
>system powerpc, darwin7.9.0
>DBI version 0.1-9
>/usr/local/mysql/bin/mysql Ver 12.22 Distrib 4.0.25, for apple-
>Remail@example.com mailing list
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 19:01:13 EST