mySQL Host access

Earthednet-wp prothero at earthednet.org
Thu Jan 7 12:53:04 EST 2016


Peter,
I do this on my server. I keep the php on my server. Then I only have to allow access from "localhost' because the php is being run on the server. The php is accessed with "post" command from livecode. If you need an example, I can send you a sample stack, with some sample php.
Bill

William Prothero
http://es.earthednet.org

> On Jan 7, 2016, at 9:34 AM, Peter Haworth <pete at lcsql.com> wrote:
> 
> 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"
> 
> 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 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