[R] RMySQL problems

From: Roeland Hancock <rhancock_at_email.arizona.edu>
Date: Tue 18 Oct 2005 - 17:41:26 EST

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
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 Received on Tue Oct 18 17:49:33 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:40:45 EST