R help - Nov 2010 - 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

	[[alternative HTML version deleted]]

library(RMySQL)
conn <- dbConnect(MySQL(), user = 'user', password =
'password', host = '
your_host.com')

Look at http://biostat.mc.vanderbilt.edu/RMySQL for more information

On Fri, Nov 5, 2010 at 5:04 PM, Jan Theodore Galkowski <
bayesianlogic@acm.org> wrote:
> 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
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@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.
>


-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]

> -----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.

    https://stat.ethz.ch/mailman/listinfo/r-sig-db

Hope this is helpful,

Dan

Daniel Nordlund
Bothell, WA USA