[R] Database Connection Problem with RMySQL package

[Willie Y. CHEN]

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:

> library(DBI)
> library(RMySQL)
> mgr <- dbDriver("MySQL")
> con <- dbConnect(mgr, user="root", pass="*******", host="localhost", dbname="campus")
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
-- 
************************************
Decisioneering Pty Ltd

PO Box 23
Doncaster, VIC 3108
Australia

O: +61-3-98558661
H: +86-21-64205688