ISP has no remote access on connecting to MySQL database. Now what?

[stephen barncard]

Many ISPs have a security scheme in which the MySQL sever will only respond
to IPs that are registered with the current user ... be sure to look in all
your panels for something like this.

Dreamhost and On-Rev <do> allow off site connections to databases, with the
IP feature enabled.  This is extremely valuable when working with db
management applications like Navicat and the free Sequel Pro.

On Sun, Jul 1, 2012 at 11:03 AM, Mark Schonewille <
m.schonewille at economy-x-talk.com> wrote:

> Malte is right. Also, ISP's more often don't than do allow remote database
> access. Here's an example (but no downloads) of a product I made for a
> customer to cope with this problem: http://qery.us/2b1 It all works
> through PHP. If you have RevServer, you could use iRev instead of PHP. I
> use a PHP script that handles the $_POST array and a LiveCode script that
> sends multi-part form data to the server.
>
> --
> Best regards,
>
> Mark Schonewille
>
> Economy-x-Talk Consulting and Software Engineering
> Homepage: http://economy-x-talk.com
> Twitter: http://twitter.com/xtalkprogrammer
> KvK: 50277553
>
> Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour
> spaces. http://www.color-converter.com
>
> On 1 jul 2012, at 19:45, Malte Brill wrote:
>
> > Hi William,
> >
> > best bet is to implement a piece of middleware (e.G. a PHP script) you
> can get the data from. Then the server does the connection to the mySQL
> database and you retrieve the data using a http request.
> >
> > Hth,
> >
> > Malte
>
>
> _______________________________________________
> 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
>



-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  <http://www.google.com/profiles/sbarncar>