[R] RMySQL problems

[Christian Schulz]

Hi,

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.

regards, christian

DBI version 0.1-9
RMySQL 0.5-5

         _             
platform i386-pc-mingw32
arch     i386          
os       mingw32       
system   i386, mingw32 
status   Patched       
major    2             
minor    1.1           
year     2005          
month    09            
day      07            
language R           

I use


>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,  
>host="localhost", dbname="hh03");
>Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not  
>connect hothand at 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.
>
>Any suggestions?
>
>Thanks in advance.
>
>
> > version
>          _
>platform powerpc-apple-darwin7.9.0
>arch     powerpc
>os       darwin7.9.0
>system   powerpc, darwin7.9.0
>status
>major    2
>minor    1.1
>year     2005
>month    06
>day      20
>language R
>
>DBI version 0.1-9
>RMySQL 0.5-5
>
>/usr/local/mysql/bin/mysql  Ver 12.22 Distrib 4.0.25, for apple- 
>darwin7.9.0 (powerpc)
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
>
>  
>