Mysql Workbench on Ubuntu 14.10

As a friendly tip for anyone else who:

  1. Just upgraded to Ubuntu 14.10
  2. Use Mysql Workbench a lot
  3. Use the built in TCP/IP over SSH to connect to remote servers.

There’s a big chance that you saw this:

Selection_001

Problem

In Ubuntu 14.10 the package python-paramiko was upgraded to 1.15. The package is used by Python apps to create ssh connection. In version 1.15 it seems that paramiko has problem with some servers due to a mismatch in what protocols to support. End result is that your MySQL Workbench cant connect using an ssh connection

Solution

Downgrade to python-paramiko 1.10 that was shipped with Ubuntu 14.04.

Howto

Run these two commands in the terminal.

$ wget http://launchpadlibrarian.net/167351511/python-paramiko_1.10.1-1git1build1_all.deb
$ sudo dpkg -i python-paramiko_1.10.1-1git1build1_all.deb

Comments

5 responses to “Mysql Workbench on Ubuntu 14.10”

  1. Rogerio Vieira Xavier Avatar

    Excelent topic.

    Solved my problem!!!
    Thanks!!!

  2. Peter Avatar

    This didn’t work for me. After installing the .deb paramiko 1.15.1 was installed according to pip:

    $ pip freeze | grep paramiko
    paramiko==1.15.1

    Mysql Workbench was still failing with the same error. Downgrading with pip did the trick:

    $ sudo pip install -U paramiko==1.10.1

  3. erik@torgesta.com Avatar

    Peter, sorry to hear that my solutio didn’t work and thanks for sharing what worked for you.

  4. Nithaele Avatar
    Nithaele

    Problem solved.
    Thanks !

  5. andrew Avatar

    Worked a charm, thanks

Leave a Reply

Your email address will not be published. Required fields are marked *