specifying a custom port for a MySQL database connection

John Craig jc at spl21.net
Wed Nov 15 16:44:21 EST 2006


I had the same problem a while back - some kind person on the list came 
up with the answer - so here it is regurgitated!

The correct syntax is;
put revOpenDatabase("MySQL", dbHost, dbName, dbUser, dbPass, dbPort) into db

HTH

JC

Chris Sheffield wrote:
> Hi all,
>
> I'm having a problem. Using the revOpenDatabase function, the docs say 
> that you can specify a port number by specifying the host, followed by 
> a colon, followed by the port number. So something like 
> "localhost:3306". Is this correct? Because I've tried it and I get an 
> error "Unknown MySQL server host 'localhost:3306' (1)".
>
> Has anyone used this and made it work? I need to figure out a solution 
> for this asap.
>
> Thanks,
> Chris
>
>
>
> ------------------------------------------
> Chris Sheffield
> Read Naturally
> The Fluency Company
> http://www.readnaturally.com
> ------------------------------------------
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>





More information about the use-livecode mailing list