On 21/06/2012 17:17, Brett Robinson wrote:
Hi, I have tried to figure this out from the help files and lists but not
managed it
I can access a local MySQL database from R running on my Windows XP PC. What I
want to do is access a MySQL database on a linux web server, for which I have
admin access. I can't figure out how to set up odbcConnect. For local access
I set up a dsn via the windows admin interface. I have tried to set up dsn for
access to our web server by providing the IP address and user id and passwords
but get the error below.
"Connection failed: [HY000] [MySQL] [ODBC 5.1 Driver]Host
'host86-180-150-32.range86-180.btcentralplus.com' is not allowed to connect to this MySQL
server"
(1) That is not a 'web server': remote MySQL connections use TCP/IP but
not 'the web'.
(2) This really is not an R question. Try another client until you get
the DSN right (and likely you need to talk to the server administrator,
since quite likely you do not have permission to do what you are trying
to do. And R-sig-db would be the appropriate R list, if any.
Thanks
Brett
--
Brian D. Ripley, rip...@stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595
______________________________________________
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.
