At this moment passwords to unlock keys have to be entered both in MySQL Workbench and the pageant. Specify private ssh key in the appropriate section of the Workbench’s “Server Instance Editor” Ĥ. Generate keys, using either openssh on Linux, OSX, Cygwin, or using PuTTYgen Ģ. More details are given in the mentioned bazaar guide Bzr and SSH.Īnd this worked! Let me sum up the steps:ġ. The conversion is done using PuTTYgen, then the key is loaded in the pageant. So the latter way turned into conversion of the openssh private key into PuTTY ppk format. Even if you've installed the latest version of MySQL you may proceed to control panel, uninstall latest workbench, download from archive MySQL workbench 6.3 CE and install it.

Could that be that paramiko can not handle openssh keys on Windows, or openssh’s encryption method?Įrror message on connect via SSH public keysīazaar has similar issues on Windows, the solution they suggest is to either put keys into. Moving key to $HOME/.ssh/id_rsa did not help. That did not work, just as the bug report had said. Naturally my first attempt was to simply specify path to the private key file in the server settings, just as I would do in Linux or OS X. After that the public key was added to ~/.ssh/authorized_keys and the private one was moved to the Windows box. MySQL Workbench 5.2.34+ is installedįirst of all I created an encrypted pair of RSA keys, using Linux box’s ssh-keygen. Windows – well, it is an XP SP3 i386 box. Linux – Ubuntu 11.04, sshd is set up to deny password auth.

Why Windows you would ask? Because interactions for Linux->Linux and for Mac OS X -> Linux simply work using the Unix way, while for Windows you may need some extra actions to do. For additional information about installing a MySQL server, see Installing and Upgrading MySQL. For additional information about connecting to a MySQL server, see Chapter 5, Connections in MySQL Workbench. There will be no explanation of the public key authentication itself here, rather the actual setup and steps to have a public key auth for Windows(client) -> Linux(server) working. MySQL server: Although it is not required, MySQL Workbench is designed to have either a remote or local MySQL server connection. Recently I was trying to reproduce a bug related to SSH public key authentication, so here I would like to share some of my experience. It happens that sometimes you need to access a remote box which supports ssh key authentication.

Mysql workbenchfor windows xp