Re: Connecting directly to On-Rev SQL

2009-11-23 Thread Pierre Sahores
Why not but the irev or php or... ways lets us a safer solution ;-) Le 23 nov. 09 à 17:35, stephen barncard a écrit : Not true. Security issues aside, one can use % as the ip address to accept any address for a MySQL client connection. See "Remote Database Access Hosts" in the Cpanel. 20

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread stephen barncard
and I should add that if one has to only have to deal with a single or series (comma delimited) of remote IP, use that for much better security. - Stephen Barncard San Francisco http://houseofcubes.com/disco.irev 2009/11/23 George C Brackett > And I can verify from exper

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread George C Brackett
And I can verify from experience that this approach works just fine. George On Nov 23, 2009, at 11:35 AM, stephen barncard wrote: Not true. Security issues aside, one can use % as the ip address to accept any address for a MySQL client connection. See "Remote Database Access Hosts" in the Cpanel

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread stephen barncard
Not true. Security issues aside, one can use % as the ip address to accept any address for a MySQL client connection. See "Remote Database Access Hosts" in the Cpanel. 2009/11/22 Pierre Sahores > Hi Bob, > > For security reasons, the on-rev servers are set to accept localhost MySQL > connexion

Re: Connecting directly to On-Rev SQL

2009-11-23 Thread Pierre Sahores
Hi Bob, For security reasons, the on-rev servers are set to accept localhost MySQL connexions only. To let your stack bind the MySQL server, she need to tell to an irev script what to query/request from the db. Works like a charm in this way. Best Regards, Le 22 nov. 09 à 19:12, Bob Sne

Re: Connecting directly to On-Rev SQL

2009-11-22 Thread stephen barncard
One can create any number of MySQL databases in the ON-REV control panel. This arrangement is typical of ISP hosted MySQL servers: One has to set up each new database through the control panel, One cannot create new databases from within a MySQL instance here. One can create as many tables as one

Connecting directly to On-Rev SQL

2009-11-22 Thread Bob Sneidar
Hi all. I have browsed through the Use Rev posts but can't seem to find any info on this. I'd like to connect directly to the On-Rev MySQL from my Rev stacks. What is the URL or address to do that? Bob___ use-revolution mailing list use-revolution@li