I would like a small help on establishing a connection on a remote
MySQL database using R
I am able to connect to a localhost database in mysql and perform
queries, but when I try to connect to a database on a remote host (to
which I usually have access through ssh) I fail to establish a
connection.
> library(RMySQL)
> drv <- dbDriver("MySQL")
> con_clinic <- dbConnect(drv, "pippo", "7777", "127.0.0.1", "3308",
dbname="DB")
Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not
connect [EMAIL PROTECTED] on dbname "DB"
Error:Access denied for user 'pippo'@'localhost' (using password: YES)
When I connect to the database outside R, I usually first establish a
ssh tunnel
ssh -L 3308:localhost:3306 [EMAIL PROTECTED]
then, I connect to mysql db using MySQL query browser, that's why I
have configured the same kind of connection in R as well. My tunnel
ssh connection was active when I tried to connect through R
Many thanks
Cinzia
______________________________________________
[email protected] 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.
