Can't connect to MySQL server using revOpenDatabase

jbv jbv.silences at Club-Internet.fr
Mon Oct 18 08:51:54 EDT 2004



James,

Yes, I know these stacks.
But the MySQL.tests stack doesn't include the situation
where MySQL isn't configured on port 3306...

Thanks anyway,
JB


> JB -
>
> I would suggest trying Sarah's MySQL Rev code.  It really helped me get
> a jump start on connecting Rev to MySQL (running on MacOSX Panther).
> Here's Sarah's MySQL stacks:
> http://www.troz.net/Rev/RevProjects/MySQL.rev.gz
> http://www.troz.net/Rev/RevProjects/MySQLtests.rev.gz
>
> Be sure to check out Sarah's explanations of these stacks here:
> http://www.troz.net/Rev/
> plus many other useful stacks (Thank you, Sarah!).
>
> -James
>
> On Oct 18, 2004, at 7:05 AM, jbv wrote:
>
> > Hi list,
> >
> > Still fighting with databases connections...
> >
> > I'm trying to open a connection to MySQL using
> > revOpenDatabase in the IDE and I get this error :
> >
> > Can't connect to MySQL server on 'www.example.com:5432' (61)
> >
> > ALTHOUGH IT WORKS WITH the DB Query
> > Builder (connection status : connected) !!!!
> >
> > MySQL is configured on port 5432, which is open in
> > the firewall.
> > Here's the script I'm using :
> >
> > on mouseUp
> >   put "root" into myUSR
> >   put "******" into myPWD
> >   revSetDatabaseDriverPath "/Macintosh HD/Desktop Folder/Revolution
> > 2.5/components/global
> > environment/database_drivers/MacOSX/dbmysql/Contents/MacOS/dbmysql"
> >   get
> > revOpenDatabase("MySQL","www.example.com:5432","myDB",myUSR,myPWD)
> >
> >   put it
> > end mouseUp
> >
> > In the archives, I found a msg from someone saying
> > that "root" isn't accepted by MySQL as user on a
> > distant machine, but in that case why does it work
> > in the DB Quary Builder ?
> >
> > What am I missing or doing wrong ?
> >
> > Thanks,
> > JB
> >
> >
> > _______________________________________________
> > use-revolution mailing list
> > use-revolution at lists.runrev.com
> > http://lists.runrev.com/mailman/listinfo/use-revolution
> >
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution



More information about the use-livecode mailing list