?
Solved

Can't connect to MySQL 10060

Posted on 2003-02-18
8
Medium Priority
?
7,346 Views
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

shern
0
Comment
Question by:shern
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 2

Expert Comment

by:laurly
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?

myodbc:
http://www.mysql.com/downloads/api-myodbc.html


laurly

0
 
LVL 4

Expert Comment

by:ajsaasta
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.

-Ari
0
 

Expert Comment

by:Airgazm
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?
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

Expert Comment

by:Airgazm
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.

-Air
0
 

Author Comment

by:shern
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
0
 

Author Comment

by:shern
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.

Anyone?
0
 
LVL 1

Accepted Solution

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

Computer101
E-E Admin
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
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…

777 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