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.

Reply via email to