mySQL Host access

Matthias Rebbe | M-R-D matthias_livecode_150811 at
Thu Jan 7 13:17:47 EST 2016

> Am 07.01.2016 um 18:34 schrieb Peter Haworth <pete at>:
> 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 "@.

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.


> 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 <>
> Home of lcStackBrowser <> and
> SQLiteAdmin <>
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the Use-livecode mailing list