> Am 07.01.2016 um 18:34 schrieb Peter Haworth <p...@lcsql.com>: > > It seems that to access a mySQL database on my web host's servers from a > Livecode program, I have to configure "Allowable hosts" in the database > configuration. That can be an ip address or a domain name such as "@. > mydomain.com” >
if i remember right you could use %.%.%.% instead of the ip address to allow all ip addresses to remotely connect to the MySQL DB. But i wouldn´t do that. I would create a php or lc script on the server which makes all the communication with the MySQL db and then let the Desktop App call the php/lc file on the server. The php/lc file would then return the needed data to the Desktop App. It´s much safer then to allow remote connections to the MySQL DB. Matthias > The program in question will be used by perhaps a half dozen users, all > from their home computers and likely using different internet providers so > it appears every time I give the program to a new user, I will have to add > either their ip address (if it's fixed) or a domain as above. > > Is this common practice when accessing mySQL on a host server? If so, is > there a better way to set about accessing a mySQL database in these > circumstances, perhaps using php scripts on the server instead of accessing > the db directly with the LC database functions? > > Pete > lcSQL Software <http://www.lcsql.com> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
