469,575 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

Is there anyway to access MySQL database using ODBC without opening port 3306?

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

Sep 20 '07 #1
3 4819
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.

Sep 20 '07 #2
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.nowwrote:
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.

Sep 20 '07 #3
C.
On 20 Sep, 22:31, ChronoFish <d...@chronofish.comwrote:
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.
Sep 21 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Phil Powell | last post: by
reply views Thread by Mike Chirico | last post: by
3 posts views Thread by Kevin Killion | last post: by
4 posts views Thread by Richard | last post: by
oll3i
5 posts views Thread by oll3i | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.