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

Lan Connection

forums forums SQLyog Using SQLyog Lan Connection

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #9153
      brainstorms
      Member

      Hello,

      I am a new user, have searched the forum but cannot find this query.

      I have a LAN with MySQL set up on one machine (the test server), and DWMX and SQLyog on another.

      I cannot connect using localhost or the testing server IP address., getting error 2003.

      Both machines on XP Pro, SQLyog excepted on the firewall.

      The Mysql connections on DWMX work fine.

      Connection to remote hosts work fine.

      Any suggestions/experience of setting this up on a LAN much appreciated.

    • #18869
      peterlaursen
      Participant
      Quote:
      I have a LAN where with MySQL set up on one machine (the test server), and DWMX and SQLyog on another.

      I cannot connect using localhost or the testing server IP address.

      SQLyog and MySQL are on different computers so of course “localhost” won't work from SQLyog. The test server ip however should work.

      What is the error message you are getting ??

      Since DremWeaver connects you should have user/pw/port correct, if you use same connection parameters. There could be a user_limit of “1” (and other special settings with MySQL) so that SQLyog can't connect when DW does, but that is very unusual.

      Does the user you try to connect with from SQLyog have the privilege to access MySQL from remote? If server is a windows machine have you tried then to install SQLyog here and see it that works ?

Viewing 1 reply thread
  • You must be logged in to reply to this topic.