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
--