Posted by ChronoFish on 09/20/07 21:31

Just to be clear, you do not have to use port 3306 - but you do have
to use *some* port. Accessing it from a 2nd machine means the local
firewall rules need to allow it. Opening up to outside the network
means the network router/firewall/ISP needs to allow it. If you're
only connecting locally, then use localhost rather than the machine
name.

-CF

On Sep 20, 5:08 pm, Ivan Marsh <anno...@you.now> wrote:
> 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]