Bug #61325 Start Command Line Client doesn't work for connections using SSH
Submitted: 27 May 2011 12:38 Modified: 13 Nov 2012 3:01
Reporter: Daniël van Eeden Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.34 OS:Linux
Assigned to: CPU Architecture:Any

[27 May 2011 12:38] Daniël van Eeden
Description:
1. right click a connection which uses ssh
2. click "Start Command Line Client"
3. a password prompt appears. Enter a password.

Expected: A commandline database prompt

Actual: Nothing

strace/ps shows it's trying to execute "mysql -uuser1 -hhost1.example.com -P3306 -p"

1. It's not clear which password is needed. (SSH or MySQL password?)
2. There is no indication about which server it's trying to connect to (Did I click on the correct host? What about connecting to multiple hosts at the same time?)

How to repeat:
See Description.

Suggested fix:
1. Add a line before the password prompt:
"Enter the MySQL password for <user>@<host>"

2. Use an SSH tunnel as it's already configured for the connection.

3. Use the stored password.
[31 May 2011 8:40] Valeriy Kravchuk
On 32-bit Ubuntu 10.04 I entered password for MySQL user, and got command prompt.

More clear explanation on what password is needed, as well as using stored password, would be nice features to see though.
[31 May 2011 10:18] Daniël van Eeden
I don't think D5 is correct. This is not a feature request.

Please try to reproduce it like this:
1. Setup a db host
2. Setup a client host
3. Make sure the client can not reach the db host on port 3306. You could do this by binding mysql to 127.0.0.1 or using iptables.
4. Setup WB to use SSH to connect to the database. This should succeed. 
5. Try to use the "Start Command Line Client" option and enter the correct password.
6. The connection will not succeed.

What likely happend when you tried it was that it used a direct MySQL connection instead of the configured SSH tunnel.
[13 Nov 2012 3:01] Philip Olson
Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

 The "Start Command Line Client" feature would fail to 
 connect with SSH connections.

Thank you for the bug report.