[R] Can RMySQL run on Windows using a remote MySQL server?

Steven McKinney smckinney at bccrc.ca
Tue Jul 20 23:29:43 CEST 2010


So the answer is yes.

Install the MySQL Workbench application on your XP box
and work out the URL, account name and password, and
port connection issues to the reomte MySQL database.  
You should then have a MySQL driver available.  

Set up a User DSN or System DSN to the remote database 
using ODBC Data Source Administrator widget in 
Windows administrative tools.  

Install RMySQL, configure and enjoy.

Good luck!

Steven McKinney
________________________________________
From: r-help-bounces at r-project.org [r-help-bounces at r-project.org] On Behalf Of neatgadgets [neatgadgets at gmail.com]
Sent: July 19, 2010 3:26 PM
To: r-help at r-project.org
Subject: Re: [R] Can RMySQL run on Windows using a remote MySQL server?

I'm using Windows XP.
--
View this message in context: http://r.789695.n4.nabble.com/Can-RMySQL-run-on-Windows-using-a-remote-MySQL-server-tp2293533p2294705.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help at 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.



More information about the R-help mailing list