Posted by Ivan Marsh on 09/20/07 21:08

On Thu, 20 Sep 2007 12:56:02 -0700, Suresh P wrote:

> Hi All,
>
> I tried to access the mysql database in ODBC using ip address and
> username/password.
> It returns, "cannot connect to MySQL server on IP ADDRESS(10060)". This
> could be related to Firewall on the server.
>
> Is there anyway to access MySQL database using ODBC without opening port
> 3306?
>
> Any thoughts would be appreciated.

If you're asking if you can access MySQL remotely with ODBC without
opening up the firewall to the traffic the answer is a fairly obvious no.

If you're asking if you can access MySQL locally with ODBC use localhost
or 127.0.0.1 instead of the physical IP address... assuming localhost
isn't being blocked (little chance of that).

--
I told you this was going to happen.

[Back to original message]