Skip to content

Database Connection Problem with RMySQL package

2 messages · Willie Y. CHEN, John Bollinger

#
Folks,

I failed to create a connection to the database under MySQL DBMS in
the R system via RMySQL's method dbConnection(...).

My setup is as follows:

Microsoft Windows XP 5.1.2600
MySQL 4.1.9
R 2.0.1
DBI 0.1-8
RMySQL 0.5-5 
Both of DBI and RMySQL packages were downloaded from bell lab: 

http://stat.bell-labs.com/RS-DBI/download/index.html

My case in R is as follows:
Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not
connect root at localhost on dbname "campus")

What am I doing wrong with?... It is really an annoying question.
Thank you very much for your help and patience.

Yours truly,

Willie Y CHEN
#
On Sat, 29 Jan 2005 14:53:55 +0800, Willie Y. CHEN
<chenyong.cn at gmail.com> wrote:
Check RMySQL docs for how to use the .my.cnf file to make the
connection. We could not do it inline either, but when we put the info
into the file RMySQL worked fine.

See page three here:

http://cran.r-project.org/doc/packages/RMySQL.pdf

    jab