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

Remote Connection Over Lan

forums › forums › SQLyog › Using SQLyog › Remote Connection Over Lan

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 1, 2010 at 3:59 am #30438
      peterlaursen
      Participant

      Please read: http://webyog.com/faq/content/23/15/en/error-no-2003-can_t-connect.html

      It could be a firewall issue.

    • February 1, 2010 at 1:09 pm #30439
      fbrewer
      Member

      It was a firewall issue with AVG.

      I created an exception on port 3306, and I am now able to connect?

      What are the downsides to allowing port 3306 to be open when I am connected to the internet?

      Thanks

      Frank

    • February 2, 2010 at 4:27 am #30440
      peterlaursen
      Participant

      As the port is open the OS will allow requests on that port to be handled by the server program listening on that port (what is MySQL).  When the MySQL 'service' starts Windows will know that all incoming communication on that port shall be routed to the MySQL server.  Next the MySQL server will handle all such requests.

      Server programs act on demand/on request.  They do not initiate any action themselves. So if the shall be of any use it is required that client programs are allow to send a requests to initiate an action. That requires some kind of open communication 'channel' (a port, a named pipe or whatever). If you don't have such communication open option the server is no use with clients connecting from other machines. 

      So you will have to decide if you trust if the MySQL server will handle illegal requests properly …

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