Database sync with tunnel defaults to "root"

[rbreault]

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…

[peterlaursen]

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 ??

[Ritesh]

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.

[rbreault]

Ohh… was a local port issue… thanx!

Very deceiving error message though… 😕

[Author]

Posts