The test connection dialog is incorrectly indicating a failure to connect when using correct SSH parameters in the Drivers tab.
Even though the Test Connection explains there is a failure, you can still connect and use the Schema Browser and Query Analyzer for this connection.
In the Server Registration Dialog use:
Host: <localhost | IP address of MySQL host>
Port:<3306 | or custom Port #>
The initial connection will be to the SSH server with the SSHHost and SSHPort values, then the connection will be forwarded to the MySQL Host and Port value. So, "Port" is the port number which MySQL is listening on.
In the Server Registration Dialog use:
Host: <localhost | IP address of MySQL host>
Port:<3306 | or custom Port #>
In the Server Registration > Parameters tab use your ssh information in a parameter string like the following:
?socketFactory=SSHSocketFactory&SSHHost=ZZZ.ZZZ.ZZZ.ZZZ&SSHPort=22&SSHUser=n&SSHPassword=XXXXXX
where ZZZ are digits for the IP Address of the ssh server you are connecting to
and n is the ssh user login
and x is the password entered for the ssh user n
The port listed at the very end as 3306 is the port used in the Server Registration General tab for port
We will skip, plain socket test if user has connfigured
socketFactory=SSHSocketFactoryin Drivers Tab.