> 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 > > [...] > > > 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.
Make sure your MySQL server accepts pre-4.1-style passwords for the user you log on with (cf. http://dev.mysql.com/doc/mysql/en/old-client.html). The MySQL library included in RMySQL 0.5-5 comes from the 4.0.18 distribution and uses an old authentication protocol that isn't compatible with the one implemented in MySQL 4.1.x. Hope this helps. Michael ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
