Can't connect to MySQL server using revOpenDatabase

jbv jbv.silences at Club-Internet.fr
Mon Oct 18 06:05:42 CDT 2004


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




More information about the use-livecode mailing list