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.
Thanks,
Suresh P
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.
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
> 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.
On 20 Sep, 22:31, ChronoFish
> 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.
>
Or if remote, use a tunnel (e.g. via ssh) - but I suspect you're not
playing in the league where that's an option.
C.