Remote Ssh Tunnel Remote And Local Issue

[LarryEitel]

When I connect to a REMOTE connection via SSH AND a LOCAL connection I can no longer access my local mysql service, i.e., phpmyadmin can no longer connect. I am trying to synchronize from REMOTE to LOCAL. When I go to SELECT a database from LOCAL connection, I get this error:

Error No. 1045

Access denied for user 'root'@'localhost' (using password: NO)

When I close Webyog, then my phpmyadmin can again access local MySQL service.

Here are the connection parameters:

REMOTE CONNECT

MySQL TAB:

MySQL Host Address localhost

User Name root

Port 3306 Default Charset [default]

SSH TAB:

Username root SSH Port 22

SSH Host xchg.com Local Port 3306

LOCAL CONNECTION

MySQL Host Address localhost

User Name root

Port 3306 Default Charset [default]

Using the SAME parameters, I can successful manipulate both REMOTE and LOCAL connections using Navicat MySQL.

Thank you for any input.

[adarsh]

Hi,

Which version of SQLyog are you using? Have you tried the latest 5.29?

Adarsh

[LarryEitel]

Yes, it is.

adarsh wrote on Apr 11 2007, 10:31 PM:

Hi,

Which version of SQLyog are you using? Have you tried the latest 5.29?

Adarsh

[LarryEitel]

Don't mean to be a pain in the !@#$%^&*… but I registered Webyog solely because I need to synchronize remote and local db. Navicat, for some reason, started the process but failed to complete. So I then remembered webyog and figured this was the more mature robust tool. My previous trial expired so I was unable to test this feature out. SO… I took a chance and paid to register the tool.

I can't imagine this is a bug, it is more of a configuration issue. Thank you for your help with this.

LarryEitel wrote on Apr 12 2007, 02:42 PM:

Yes, it is.

[Rohit]

@LarryEitel:

Any progress for you?

[LarryEitel]

Unfortunately, no progress on this. I came back here to check. I wonder if anyone else is having success with what I am trying to accomplish. I wonder if Webyog gives refunds? I have a variety of MySQL GUI tools. I purchased webyog for the sole purpose of sync'ing db's.

Rohit wrote on Apr 17 2007, 12:22 AM:

@LarryEitel:

Any progress for you?

[adarsh]

Hi,

Quote:

REMOTE CONNECT

MySQL TAB:

MySQL Host Address localhost

User Name root

Port 3306 Default Charset [default]

SSH TAB:

Username root SSH Port 22

SSH Host xchg.com Local Port 3306

LOCAL CONNECTION

MySQL Host Address localhost

User Name root

Port 3306 Default Charset [default]

I think I got the issue. You are using port 3306 as “local” port in SSH tab. Pls. use a different value than 3306.

That is the reason why you are not able to access MySQL after starting SQLyog. MySQL is no longer able to “listen” on Port 3306.

All Webyog products come with a 90 day money back guarantee. If you are a registered Enterprise user, you should use the ticket system for priority support.

http://www.webyog.com/CustomerArea

[peterlaursen]

You can make a screendump of connection settings 8all relevant tabs) and attach to a ticket.

Fake passord and similar details as you like!  But if we could have remote access (not to your data but just a 'dummy' database) that would be best of course.

[LarryEitel]

Thank you for helping me resolve that issue. Changing the local port did the trick. Thanks! 🙂

peterlaursen wrote on Apr 19 2007, 02:00 AM:

You can make a screendump of connection settings 8all relevant tabs) and attach to a ticket.

Fake passord and similar details as you like! But if we could have remote access (not to your data but just a 'dummy' database) that would be best of course.

[Author]

Posts