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-boun...@r-project.org [r-help-boun...@r-project.org] On Behalf Of 
neatgadgets [neatgadg...@gmail.com]
Sent: July 19, 2010 3:26 PM
To: r-help@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@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.

______________________________________________
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.

Reply via email to