Unsupported Screen Size: The viewport size is too small for the theme to render properly.

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

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Error No. 2003, Can't Connect To Mysql Server (10060

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • November 1, 2011 at 11:31 am #12488
      Sara
      Member

      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?

    • November 1, 2011 at 11:44 am #32759
      peterlaursen
      Participant

      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.

    • November 2, 2011 at 11:12 am #32760
      Sara
      Member
      'peterlaursen' wrote:

      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?

    • November 2, 2011 at 1:17 pm #32761
      peterlaursen
      Participant

      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'.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.