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" Thanks Brett ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.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.