By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 1,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.