Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Can't connect to MySQL 10060

Posted on 2003-02-18
8
Medium Priority
?
7,451 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
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

604 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