connecting RMySQL to and external server
Use ssh forwarding to forward local port 3307 to remote port 3306 specifying the remote account and password. Then if you use local port 3306 you can access your local version of MySQL and if you use port 3307 you can access the remote version. There is some info on the MySQL site. First test it out by running the mysql command line program accessing the remote data base via port 3307 and once that works you know its ok and you can try RMySQL or RODBC packages.
On Dec 15, 2007 11:33 AM, Adrian Dusa <dusa.adrian at gmail.com> wrote:
Indeed, I noticed the "host" argument but the server demands an username and a password for the machine first, and only after that for the MySQL server. Those were the arguments I was looking for. I will study the RODBC package then, if it solves the problem. Thank you very much, Adrian On Saturday 15 December 2007, Prof Brian Ripley wrote:
It is trivial with RODBC (I know that is not what you asked, but it is the solution we found first). For RMySQL, note first that the MySQL configuration file is consulted, so the default host is specified in the client section, which is like [client] port=3306 [mysql] default-character-set=latin1 Add host=foo under [client] to change the default host. And ?dbConnect mentions a 'host' argument under '...'. That seems to work for me (provided of course the server allows connections from other machines): on my home network from Windows laptop to Linux server
library(RMySQL)
Loading required package: DBI
drv <- dbDriver("MySQL")
con <- dbConnect(drv, user="ripley", host="auk", dbname="ripley")
This mixture of using the *local* configuration file overridden by arguments is a bit dangerous: RMySQL seems not really designed for client-server operation and there are some things that definitely do not work. (As I recall, that included dbWrite as that imports a file which is on the local machine.) On Fri, 14 Dec 2007, Adrian Dusa wrote:
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
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.