Victor Walch Michnowicz

is a web application developer

Get MySQL Workbench to Connect to MySQL Running with Vagrant January 31st, 2013

The Problem

Getting MySQL workbench to talk to MySQL on my Ubuntu instance running with Vagrant was getting to be a pain. It turns out the solution is incredibly obvious and pretty much just requires selecting the correct drop-down menu item. I thought it would useful information to post on the interwebz, however.

MySQL connection settings

The key is selecting the "Standard TCP/IP over SSH" option as your Connection Method. I somehow ignored this for a few hours minutes. Also, be sure to reference the correct SSH Key File. In Windows it seems that to SSH to your Vagrant instance you need to use puttygen.exe to create a new private key. Do not use this key. Instead, you should use the private key that Vagrant creates for you.


blog comments powered by Disqus