Indeed, I noticed the "host" argument but the server demands an username and a password for the machine first, and only after that for the MySQL server. Those were the arguments I was looking for. I will study the RODBC package then, if it solves the problem.
Thank you very much, Adrian On Saturday 15 December 2007, Prof Brian Ripley wrote: > It is trivial with RODBC (I know that is not what you asked, but it is the > solution we found first). > > > For RMySQL, note first that the MySQL configuration file is consulted, so > the default host is specified in the client section, which is like > > [client] > > port=3306 > > [mysql] > > default-character-set=latin1 > > Add host=foo under [client] to change the default host. > > And ?dbConnect mentions a 'host' argument under '...'. That seems to work > for me (provided of course the server allows connections from other > machines): on my home network from Windows laptop to Linux server > > > library(RMySQL) > > Loading required package: DBI > > > drv <- dbDriver("MySQL") > > con <- dbConnect(drv, user="ripley", host="auk", dbname="ripley") > > This mixture of using the *local* configuration file overridden by > arguments is a bit dangerous: RMySQL seems not really designed for > client-server operation and there are some things that definitely do not > work. (As I recall, that included dbWrite as that imports a file which is > on the local machine.) > > On Fri, 14 Dec 2007, 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)? > > > > I read the documentation on ?dbConnect (and everything I could find on > > the internet), but I failed to find some other relevant arguments. For > > example, one needs to first connect to the external machine and only > > after that to the MySQL server on that machine. Is this possible from > > within R? > > > > Thank you in advance, > > Adrian -- Adrian Dusa Romanian Social Data Archive 1, Schitu Magureanu Bd 050025 Bucharest sector 5 Romania Tel./Fax: +40 21 3126618 \ +40 21 3120210 / int.101 ______________________________________________ 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.