Can't connect to MySQL server using revOpenDatabase

[Hershel Fisch]

What happens when you spell it out ?
on handler
   put  
revOpenDatabase("MySQL","www.example.com:5432","myDB","myUSR","myPWD",(m 
ake sure the last comma)) into tR
   answer tR
end handler
Hershel Fisch


On Monday, October 18, 2004, at 07: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
>