revOpenDatabase - can't connect

Matthias Rebbe matthias_livecode_150811 at m-r-d.de
Mon Aug 13 18:13:43 EDT 2012


Dan,

most server do not allow remote access for security reasons. Only access from local scripts are allowed in that case. So you have to check if you can enable remote db access on that servers.

Regards,

Matthias

Am 14.08.2012 um 00:04 schrieb Dan Friedman <dan at clearvisiontech.com>:

> Greetings!
> 
> I am trying to connect to a mySQL database on a couple of remote websites.  I can connect to them via a php script run from the server so tDatabaseAddress is "localhost".  However, every attempt to connect via LiveCode (in the IDE) fails.  I have checked with the host that the address I am using is correct.
> 
> put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
> 
> All params have been confirmed correct.  But, it still fails with this error:
> 
> Unable to connect to the database
> Access denied for user 'xxxx'@'xx.xx.xxx.xxx' (using password: YES)
> 
> or
> 
> Unable to connect to the database
> Can't connect to MySQL server on 'webXX.thehost.com' (60)
> 
> 
> Any advice?
> 
> -Dan
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list