[R] RMySQL connection

[R.Alberts]

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
> m <- dbDriver("MySQL")
> m
<MySQLDriver:(1756)>
> con <- dbConnect(m, group = "mygroup")
Error in mysqlNewConnection(drv, ...) : RS-DBI driver: 
(could not connect myuser at localhost on dbname 
"mydatabase")

the .my.cnf file looks like this:

# this is a comment
[client]
user = myuser
host = localhost
password = xxxxx

[rs-dbi]
database = s-data

[mygroup]
host = localhost
database = mydatabase