[R] RMySQL connection

From: qing Jing <qjing_at_sibs.ac.cn>
Date: Fri 19 Jan 2007 - 09:02:19 GMT

Dear All,

What's wrong?
> library(DBI);
> library(RMySQL);
> mgr<-dbDriver("MySQL");
> con<-dbConnect(mgr,dbname="test");

Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect (null)@(null) on dbname "test")

I also tried another example

> library(RMySQL);
> mycon<-dbConnect(MySQL

(),user='cws',dbname="cws",host="pi",password='delores'); Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect cws@pi on dbname "cws")

I am running R 2.1.1 DBI 0.1-9 RMySQL 0.5-6 Windows XP

Thank you much for your help.

Qing Jing PhD MD

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 and provide commented, minimal, self-contained, reproducible code. Received on Fri Jan 19 22:08:41 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 23 Jan 2007 - 09:30:33 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.