On Oct 28, 2004, at 4:37 AM, R.Alberts wrote:
Hi,
I cannot connect to my mysql database from within R using RMySQL. What am I doing wrong?
I use linux SuSe 8.1 and R-2.0.0 RMySQL_0.5-5.tar.gz DBI_0.1-8.tar.gz
I get the following error in R:
library(RMySQL)Loading required package: DBI<MySQLDriver:(1756)>m <- dbDriver("MySQL") mcon <- dbConnect(m, group = "mygroup")Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect [EMAIL PROTECTED] on dbname "mydatabase")
On the mysql server, there is a user named myuser? The password for this user is xxxxxx (or whatever)? The database is called mydatabase? The host for the server is localhost (mysql is running on the same machine as R)? That user/password combination has access to mydatabase?
Can you connect from the mysql client on the same machine with those settings?
Sean
______________________________________________ [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
