MySQL Bugs: #59238: server administration not working via ssh tunnel

Bug #59238	server administration not working via ssh tunnel
Submitted:	30 Dec 2010 23:14	Modified:	1 Mar 2011 14:48
Reporter:	mickey Mouse	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.31a	OS:	Windows (7)
Assigned to:		CPU Architecture:	Any
Tags:	administrator, Broken, bugs, crap, oracle-sucks

Description:
Current MySQL Workbench (5.2.31a CE rev. 7115) is still buggy. Why did you kill good old standalone MySQL Administrator?

My MySQL server stays at my hoster's location. I can only get to it via SSH tunnel (no direct connection). There is quite an ugly way to login to it (using the key AND the password), so built-in SSH-Tunnel master could not connect to it. No problem, let me use my own tunnel provided by PuTTY. So I have PuTTY tunnel set up, and MySQL is now at 127.0.0.1:3306. Somehow it works with Query Browser part of "workbench". But when I try to add New Server to administrate (from saved Query Browser connection or from scratch), the wizard fails with an exception on a Management and OS step. Looks like it thinks that MySQL server really works on my localhost (Windows 7). But it isn't! It's just a tunnel! And, anyway, I could not change remote configuration or restarn my hoster's MySQL. I just need Administration to work with my tables, backups and look at the performance. There should be a way to SKIP this step.

How to repeat:
My MySQL server stays at my hoster's location. I can only get to it via SSH tunnel (no direct connection). There is quite an ugly way to login to it (using the key AND the password), so built-in SSH-Tunnel master could not connect to it. No problem, let me use my own tunnel provided by PuTTY. So I have PuTTY tunnel set up, and MySQL is now at 127.0.0.1:3306. Somehow it works with Query Browser part of "workbench". But when I try to add New Server to administrate (from saved Query Browser connection or from scratch), the wizard fails with an exception on a Management and OS step.

Suggested fix:
And, anyway, I could not change remote configuration or restarn my hoster's MySQL. I just need Administration to work with my tables, backups and look at the performance. There should be a way to SKIP this step.

There was a similar report recently where it also "looks like it thinks that
MySQL server really works on my localhost".  In this case MySQL was running in a VM with Linux. Host OS was Windows where also WB was installed.

Peter
(not a MySQL person)

Do you have any real local MySQL services defined? I have 3, and Workbench indeed looks only for one of them when trying to get configuration file. 

As soon as I select any of existing local MySQL services, I can proceed and get the way to work with remote server via tunnel. But I think you should just be able to give it any local my.ini/my.cnf file...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".