MySQL Workbench TCP/IP over SSH help please.
I am trying to create a connection to MySQL through MySQL Workbench's TCP/IP over SSH connection.
I am following this guide:
When I try to test the connection, I get the error:
"Failed to connect…tunnel connection cancelled."
Even the Workbench error logs give no clearer picture:
"Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details."
The doozy here is that I can easily connect to the server through SSH with Putty.
I am using a key to authenticate.
Any ideas on where to look? I've been lost on this for a day or two now.
2 Replies
#!/bin/sh
ssh -X -L 127.0.0.1:3306:127.0.0.1:3306 myaccount@mysite.domain
Then locally I just set up a connection in MySQL Workbench to 127.0.0.1 on port 3306.
@timuza:
Hey guys.
When I try to test the connection, I get the error:
"Failed to connect…tunnel connection cancelled."
Even the Workbench error logs give no clearer picture:
"Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details."
Did you specify that you're using the key for MySQL workbench? This seems related: