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

Database sync with tunnel defaults to "root"

forums forums SQLyog SQLyog: Bugs / Feature Requests Database sync with tunnel defaults to "root"

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #8998
      rbreault
      Member

      I've setup my Win 2003 server with OpenSSH and everything works great accessing it remotely via SSH. But when trying to setup a Database Sync, it appears that after the source and target are set, the program trys to verify access to both and the remote fails with an “Access Denied Error for 'Root'@'server'” error. The user name “root” isn't being used at all. It seems to default to that name. If I manually edit the XML file with the SSH fields, and execute manually, it fails with a “Could not connect to TARGET MySQL server” error in the SJA.log file. Weird.

      Was working great till setup with SSH…

    • #17898
      peterlaursen
      Participant

      I have never been working with ssh, but do you fill out BOTH the “server” and the “tunnel” tab for the connection ?

      From the sqlyog-help:

      To understand the setup better, let us connect to a MySQL server using a real life example.

      E.g. Your website is hosted on 234.56.65.78. This server also has SSH server running and listening on port 22. Your MySQL server is located on server 234.56.65.79. This machine only allows connection from localhost or machine within the same network (e.g. 234.56.65.78). You publish your website on 234.56.65.78 using the username and password provided by your ISP. ex. the username and password provided is ssh_user and ssh_pwd respectively.

      In this particular case you have to put in the following value for various options:

      Server Tab

      MySQL Host Address 234.56.65.79

      Username Your mysql user name.

      Password

      Your mysql password.

      Database

      The database that you want to connect to. You can leave this field blank.

      Port

      The port MySQL is listening. By default it is 3306.

      Tunnel Tab

      Username

      ssh_user

      Password ssh_pwd

      SSH Host 234.56.65.78

      SSH Port 22

      Local Host This is always localhost.

      Local Port Any port that is unused on your local machine. If you dont have a MySQL running on your machine then you can provide 3306.

      ********************************************************************************

      ****'

      “Access Denied Error for 'Root'@'server'” is a MySQL server error

      “Could not connect to TARGET MySQL server” is a SQLyog error

      I suspect that first you provide wrong/none password on the “server tab”, next you mismatch users for ssh and mysql ??

    • #17899
      Ritesh
      Member

      What are the local port you are specifying for both source and target server?

      SQLyog will create an instance of SSH tunneler in your local machine on the specified ports and will use it for SSH Tunneling. So you need to make sure that both the local ports are different.

    • #17900
      rbreault
      Member

      Ohh… was a local port issue… thanx!

      Very deceiving error message though… 😕

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