mySQL Host access

Peter Haworth pete at lcsql.com
Thu Jan 7 20:15:37 CET 2016


Thanks Matthias, definitely seems like php on the server is the way to go.
I guess designing the interface protocol between the LC app and the php
scripts is my next step.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Thu, Jan 7, 2016 at 10:17 AM, Matthias Rebbe | M-R-D <
matthias_livecode_150811 at m-r-d.de> wrote:

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