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, ripley at 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