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 exte
On Saturday 15 December 2007, you wrote:
> Use ssh forwarding to forward local port 3307 to remote port 3306
> specifying the remote account and password. Then if you use local port
> 3306 you can access your local version of MySQL and if you
> use port 3307 you can access the remote version. Th
On Saturday 15 December 2007, Prof Brian Ripley wrote:
> On Sat, 15 Dec 2007, Adrian Dusa wrote:
> > Indeed, I noticed the "host" argument but the server demands an username
> > and a password for the machine first,
>
> But you said 'connect to', not 'log in to', so how were we to know that?
>
> >
Use ssh forwarding to forward local port 3307 to remote port 3306
specifying the remote account and password. Then if you use local port
3306 you can access your local version of MySQL and if you
use port 3307 you can access the remote version. There is some
info on the MySQL site. First test i
On Sat, 15 Dec 2007, Adrian Dusa wrote:
>
> Indeed, I noticed the "host" argument but the server demands an username and a
> password for the machine first,
But you said 'connect to', not 'log in to', so how were we to know that?
> and only after that for the MySQL server.
> Those were the argum
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 Sa
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=
7 matches
Mail list logo
