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

Connection Denied

forums › forums › SQLyog › Using SQLyog › Connection Denied

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 19, 2005 at 3:53 pm #9234
      peterlaursen
      Participant
      Quote:
      Hi I have my desktop and laptop connected via a router (desktop via cable, laptop via WIFI). They both have a webserver and MySQL. I want to synchronize the laptop dbase to the desktop dbase… hence SQLyog. I am trying to set up a synchronization session via the wizard, but I am having problems getting through – I get the error msg: Error No 1045 Access denied for user root@PC2003 (using passwords YES). Both dbases have the same password for user root (which is specified). PC2003 is the internal name of the desktop PC (on which I am trying to run SQLyog). PC2003 is set up as localhost in the “Source” half of the screen, and the laptop (PC2005) is set up as 192.168.0.3 in the “Target” section. Help appreciated please.
    • September 19, 2005 at 4:09 pm #19227
      peterlaursen
      Participant

      It is a user authentication/privilege problem.

      Did you read this FAQ item:

      http://www.webyog.com/faq/23_18_en.html ?

      I have sync'ed often between two PC's on a LAN with a router as DHCP server. No problems in that. Type of (physical) network does not matter either.

      I believe in your case the problem that ROOT is only allowed to connect from 'localhost'. If not that is it, I don't understand you perfectly and I shall then ask you to explain a little more detailed (we love screenshots!)

      You could install SQLyog on PC2005 too and change the root's hosts' access from 'localhost' to '%' or just '192.168.0.%' (in case you only want to connect from your LAN).

      If you connect on port 3306 it is irrelevant if there is a webserver installed. But of course you will need it for HTTP-tunnelling. But not much use of that on a LAN!

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