Skip to content

RMySQL problems

2 messages · Roeland Hancock, Christian Schulz

Original
Roeland Hancock
# 
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)
Christian Schulz
# 
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