[R] RMySQL problems
Roeland Hancock
rhancock at email.arizona.edu
Tue Oct 18 09:41:26 CEST 2005
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)
More information about the R-help
mailing list