Yes, what happens when I do that is:

R version 2.11.1 (2010-05-31)
Copyright (C) 2010 The R Foundation for Statistical Computing
ISBN 3-900051-07-0
[snip]
> Sys.getenv("MYSQL_USER")
MYSQL_USER
"mf1"
> # As an example. Other env vars are defined.
> library(RMySQL)
Loading required package: DBI
Error : .onLoad failed in loadNamespace() for 'RMySQL', details:
call: utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM",
maxdepth = 2)
error: Registry key 'SOFTWARE\MySQL AB' not found
Error: package/namespace load failed for 'RMySQL'
>

I don't even get to do anything more.

 - Jan


On Fri, 05 Nov 2010 17:14 -0200, "Henrique Dallazuanna"
<wwwhsd@gmail.com> wrote:

  library(RMySQL)
  conn <- dbConnect(MySQL(), user = 'user', password =
  'password', host = '[1]your_host.com')
  Look at [2]http://biostat.mc.vanderbilt.edu/RMySQL for more
  information

On Fri, Nov 5, 2010 at 5:04 PM, Jan Theodore Galkowski
<[3]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]]
  ______________________________________________
  [4]R-help@r-project.org mailing list
  [5]https://stat.ethz.ch/mailman/listinfo/r-help
  PLEASE do read the posting guide
  [6]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

References

1. http://your_host.com/
2. http://biostat.mc.vanderbilt.edu/RMySQL
3. mailto:bayesianlogic@acm.org
4. mailto:R-help@r-project.org
5. https://stat.ethz.ch/mailman/listinfo/r-help
6. http://www.R-project.org/posting-guide.html
--
  Jan Theodore Galkowski  (o°)

  607.239.1834 [mobile]
  607.239.1834 [home]
  617.444.4995 [work]

 bayesianlogic@acm.org
 http://www.linkedin.com/in/deepdevelopment


 "Eppur si muove." --Galilei



	[[alternative HTML version deleted]]

