sqlite & mySQl hassles...

Gerry Orkin gerry.orkin at gmail.com
Thu Aug 25 23:11:03 EDT 2011


Is the mySQL database set up to allow access from the device? I believe you need to set the remote client IP address for mySQL installs, for security reasons - if it's a typical virtual host install, it'll probably be set to allow access from your desktop machine (the machine you most likely used to set up the database...) but not other IP addresses...

Gerry

>> 
>> The MySQL script that works... but just not on a real device...
>> /* get the data from the database */
>>     get revOpenDatabase("mysql","www.xxxxxx.com
>> ","xxxxxxxx","xxxxxxx","xxxxxxx")
>>     put it into gDatabaseRef




More information about the use-livecode mailing list