Setting up local MySQL applications

Below is a list of basic guides to setting up MySQL applications on your host box to communicate with databases located in your guest VMs.

Sequel Pro (OS X)

Choose connection type "SSH" and complete the connection details as follows:

Name: Whatever you'd like to label this connection.

MySQL Host: value of boxipaddress in settings file

Username: "root"

Password: value of mysql_root_password in settings file

Database: value of dbname in settings file (optional)

Port: value of mysql_port in settings file

SSH Host: value of boxipaddress in settings file

SSH User: "vagrant"

SSH Key: "~/.vagrant.d/insecure_private_key" (browse to this file by clicking the key icon)

MySQL Workbench

As above - the values go in the following dialog: