Description:
Typing a correct MySQL connection password into the modal dialog (following an SSH Tunnel password modal dialog) fails to connect to the server.
Pasting the identical typed MySQL connection password into the same modal dialog on the same connection (following an SSH Tunnel password modal dialog) successfully connects to the server.
Repeated attempt details...
Numerous painstaking attempts to ensure the correct string is being typed fails to result in an expected successful connection to the server.
Generally, the first (though in some cases, second) follow-up attempt to paste the same string (after repeated typing failures) results in a successful connection.
Consideration of outside mechanisms that interfere with typed strings seems to conflict with the ability to successfully type the SSH Tunnel's password (for the local machine's SSH key) in the preceding dialog.
How to repeat:
Create a known working (host/port/username) connection in Manage Server Connections
> Connection Method: Standard TCP/IP over SSH
* Without a stored password in > SSH Password
* With a working > SSH Key File
* Without a stored password in (MySQL) > Password
FAILS:
MySQL Connections > (click the connection w/ SSL Tunnel) > (modal dialog) Open SSH Tunnel "Please enter password for the following service:" Password: [keyboard typed string + Enter] > (modal dialog) Connect to MySQL Server "Please enter password for the following service:" Password: [keyboard typed string + Enter] > "Cannot connect to Database Server"
"Your connection attempt failed for user 'casino' from your host to server at [hostname redacted]:3306:
Can't connect to MySQL server on '127.0.0.1' (61)
Please:
1 Check that mysql is running on server [hostname redacted]
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the casino has rights to connect to [hostname redacted] from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for [hostname redacted] connecting from the host address you're connecting from"
CONNECTION SUCCEEDS:
Same as above but for second password: [keyboard paste string + Enter]
