473,569 Members | 2,845 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 5213
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.no wwrote:
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...@chronofis h.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
3244
by: Phil Powell | last post by:
I've read some online resources that utilize various MySQL command-line actions to migrate data from Access to MySQL. The situation is this: a group of co-workers of mine will be using an Access db in a shared source (for now, a directory.. ???) to be able to generate reports on the fly. What they want to do is to be able to migrate that...
0
3931
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest version of this document can be found at: http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
16
27880
by: MLH | last post by:
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my...
7
8835
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and...
11
6566
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am...
1
3362
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer uses his own php shopping cart to receive customer orders. The configuration was done via cPanel with no external modifications - which produced...
3
9673
by: Kevin Killion | last post by:
I've recently features to a system by making use of some simple MySQL access routines. It works fine at most test locations, correctkly accessing a MySQL database on an internet server. However, at certain test sites, I cannot access the database. We're online, and I can access web files, for example. But when trying to say hello to that...
4
3005
by: Richard | last post by:
hi there, i've got a mysql database with a research data. i would like to get some information from that database and save it as ms access database. it will be a client feature. the client clicks a button -and downloads ms access database with a certain information from the master mysql database. is it possible in php? how?
5
2025
oll3i
by: oll3i | last post by:
my librarybean package library.ejb; import java.sql.*; import javax.ejb.*; import library.common.*; @Stateless @Remote
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8119
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7668
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7964
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6281
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5218
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3637
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1209
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
936
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.