[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