[R] connecting RMySQL to and external server

[Patrick Connolly]

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
	  
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.