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

