[R] connecting RMySQL to and external server

[Adrian Dusa]

Dear list,

I learned how to connect R to a local MySQL server, using:
drv <- dbDriver("MySQL")
con <- dbConnect(drv, user="root", password="mypass", dbname="mydb")

Is it possible to connect R in this way to an external server (on a different 
machine, with a different IP)?

I read the documentation on ?dbConnect (and everything I could find on the 
internet), but I failed to find some other relevant arguments. For example, 
one needs to first connect to the external machine and only after that to the 
MySQL server on that machine. Is this possible from within R?

Thank you in advance,
Adrian

-- 
Adrian Dusa
Romanian Social Data Archive
1, Schitu Magureanu Bd
050025 Bucharest sector 5
Romania
Tel./Fax: +40 21 3126618 \
          +40 21 3120210 / int.101