Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Can't connect to MySQL 10060

Posted on 2003-02-18
Medium Priority
Last Modified: 2012-08-14
Hi all,

I have a MySQL server running on a linux that is working properly, and i have errors trying to connect to the server on a windows 98 client using ODBC. The error i am getting is Can't connect to MySQL 10060. The driver i am using is ODBC 3.51,(i wish to create a vb app using the driver to access the database) I am quite sure that the parameters that i specified for the host name etc are correct. I even downloaded the MySQL control centre to test the connection to the MySQL linux server, but it still doesnt work. I tried using the same ODBC driver and the same windows client to connect to another dummy MySQL server running on a remote windows PC and it works. Also I have a website coded in PHP that can access the MySQL database on any windows pc, so it couldn't possibly be that the MySQL server blocks out my clients IP address right?  Please help, anyone who can help me solve this problem will get 50 extra points. Thanks in advance

Question by:shern

Expert Comment

ID: 7980024
have you tryed using myodbc? its the odbc driver that mysql recomends. have you checked to be sure that you have permissions to connect to the linux server from another host?




Expert Comment

ID: 7999126
Can you connect to the mySQL server from Linux localhost?

If you are able to connect from localhost but not outside Linux, then check your firewall on Linux. Open port 3306 (which mysql is listening) to the net and you should be able to connect.


Expert Comment

ID: 8003794
Yeah, I am trying to do this too and have the exzact same problem, error 10061.  I have opened the firewall and installed the myODBC client software on my XP and I get the error.

PHP works in web pages connecting.  
So, is there some kind of change that needs to be done on the  Linux side to enable the service to outside world? A MySql setting perhaps?
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.


Expert Comment

ID: 8003899
Ok shern, one thing I just found on my MySQL installation in the MySql config file was an option set by default called "skip-networking".  Looking around I found that this needs to be removed or remarked out "#".  Try that, then stop the MySql service completely and then restart it.

After doing this, now I get a different error, saying Access Denied for Root, so I know now I am dealing with password problems, but this might fix your problem.


Author Comment

ID: 8006046
Thanks all sorry for the late response, i have yet to try out your solutions yet, but i shall now, and thanks for the help will get back soon

Author Comment

ID: 8116780
Its been a while and i still havent found a solution,
yes i am using the myodbc driver. And i can telnet to the server. Airgazm: there isnt a line in my config file that says skip-networking.


Accepted Solution

Computer101 earned 0 total points
ID: 12268111
PAQed, with points refunded (100)

E-E Admin

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question