On Sat, 29 Jan 2005 14:53:55 +0800, Willie Y. CHEN <[EMAIL PROTECTED]> wrote: > 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 [EMAIL PROTECTED] 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 > --
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 -- John Bollinger, CFA, CMT www.BollingerBands.com If you advance far enough, you arrive at the beginning. ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
