Message-ID: <200712142055.15148.dusa.adrian@gmail.com>
Date: 2007-12-14T18:55:15Z
From: Adrian Dusa
Subject: connecting RMySQL to and external server
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