[R] connecting to remote database using RMySQL

Daniel Nordlund djnordlund at frontier.com
Fri Nov 5 20:43:30 CET 2010

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]
> On Behalf Of Jan Theodore Galkowski
> Sent: Friday, November 05, 2010 12:05 PM
> To: R Project
> Subject: [R] connecting to remote database using RMySQL
> Apologies if this is the wrong place to ask.  I'm not aware of a
> mail list devoted to database interfaces.  Please direct me if
> so.
> I am trying to use TSMySQL. It loads RMySQL, and apparent the
> CRAN version has an .onLoad script which seeks out the local
> MySQL server.  If that fails, the package fails to load.
> Thing is, I'm trying to access a MySQL database on a remote
> machine for which I have authorized access. Anyone know how to do
> this, or suggest where I can find out?
> Thanks.  I have successfully accessed remote databases using
> RODBC.  Is that how I need to go?
>  - Jan

This would be your best resource for databases and R.


Hope this is helpful,


Daniel Nordlund
Bothell, WA USA

More information about the R-help mailing list