On Fri, 14-Dec-2007 at 08:55PM +0200, Adrian Dusa wrote: |> |> Dear list, |> |> I learned how to connect R to a local MySQL server, using: |> drv <- dbDriver("MySQL") |> con <- dbConnect(drv, user="root", password="mypass", dbname="mydb") |> |> Is it possible to connect R in this way to an external server (on a different |> machine, with a different IP)?
Do you use a ~/.my.cnf file? There are many settings that can be made there. Talk to your sysadmin about those. HTH -- ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~. ___ Patrick Connolly {~._.~} Great minds discuss ideas _( Y )_ Middle minds discuss events (:_~*~_:) Small minds discuss people (_)-(_) ..... Anon ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~. ______________________________________________ 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.