Re: [R] RMySQL problems

From: Christian Schulz <ozric_at_web.de>
Date: Tue 18 Oct 2005 - 19:04:17 EST

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@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@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
>
>
>
>



R-help@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 Received on Tue Oct 18 19:10:10 2005

This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 19:01:13 EST