Connecting MySQL Workbench to Acquia database

Submitted by Darren Oh on Tue, 05/10/2016 - 17:24

I’ve been able to connect to an Acquia database before from MySQL Workbench 6.2.4 on OS X, but today I was getting an error:

Could not connect the SSH Tunnel

Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details

To see the logs, go to Help » Show Log File. The relevant log file is wb.log, and the error message is

SSHException: Incompatible ssh peer (no acceptable kex algorithm)

I selected Help » Check for Updates, and was told,

MySQL WorkBench is Up to Date

You are already using the latest version of MySQL Workbench.

However, the MySQL Web site shows that version 6.2.5 was released on March 3, 2015, and the latest version is 6.3. The new version gave a different error:

Cannot Connect to Database Server

Your connection attempt failed for user 's24460' from your host to server at 127.0.0.1:3306:
  Tunnel error: Could not open port forwarding SSH channel: (1, 'Administratively prohibited')

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the s24460 has rights to connect to 127.0.0.1 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 127.0.0.1 connecting from the host address you're connecting from

Following the instructions in the Paramiko Update Tutorial didn’t help.