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 < bayesianlo...@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]]
______________________________________________ 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.
