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 ?