On Wednesday 19 December 2007, Dirk Eddelbuettel wrote:
> [...]
>
> Err, I am late to this but
>
> dbConnect(drv, user="mysqluser", password="mysqlpassword",
> dbname="anydatabase", host="xxx.xxx.xxx")
>
> works fine for me (eg on Ubuntu with a remote MySQL on some other
> box). What's the problem you were seeing?
The remote host expects a login username and password (different from the
MySQL username and password), which I cannot provide in the dbConnect
function.
The solution is to first login to the external machine (a secure login using
ssh), forwarding the MySQL port 3306 to the local port 3307 (not to interfere
with the local MySQL server), and connecting R to the remote MySQL server
using the ssh tunneling binded to local port 3307.
Best,
Adi
--
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.
