Jump to content


Photo

Error No. 2003, Can't Connect To Mysql Server (10060


  • Please log in to reply
3 replies to this topic

#1 Sara

Sara

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 01 November 2011 - 11:31 AM

After installing SQLyog to shychronize data between 2 servers and try to connect to the database on the other server during the wizard, we get error

( Error no. 2003, Can't connect to MySQL server (10060))

Although firewall port 3306 is open on both servers, and no problem with connection

Can anyone tell me what does this error mean?

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,868 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 01 November 2011 - 11:44 AM

How can you say that you get this error and at the same time "no problem with connection". This error *IS* a problem with connection! Any client connecting from same host with same connection details would face the same problem.

Does this FAQ help? http://webyog.com/fa..._t-connect.html




If you are perfectly sure that the appropriate ports have been opened check for "skip_networking' and 'bind_address' settings in MySQL configuration of the server that does not connect.
Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 Sara

Sara

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 02 November 2011 - 11:12 AM

How can you say that you get this error and at the same time "no problem with connection". This error *IS* a problem with connection! Any client connecting from same host with same connection details would face the same problem.

Does this FAQ help? http://webyog.com/fa..._t-connect.html




If you are perfectly sure that the appropriate ports have been opened check for "skip_networking' and 'bind_address' settings in MySQL configuration of the server that does not connect.



no problem with connection means that both servers can ping each other

skip_networking is off
but what about bind_address?

#4 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,868 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 02 November 2011 - 01:17 PM

Ping uses another port than what MySQL does.

'bind_address = somehost" means that teh server will refuse connections from other hosts than the one specified. The default MySQL installation of some Debian and Ubunty distributions has this setting allowing only connections from 'localhost'.


Computers make your grey hair come off ....

Peter Laursen
Webyog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users