SequelPro SSH connection to vagrant

Problem:

Configure SequelPro connection over SSH to MySQL running on a Vagrant box.

Solution:

1. Set up vagrant VM with MySQL database and user as usual.
2. Add Host entry for VM to .ssh/config.  Not strictly necessary, but also allows standard SSH connections, piping, etc:
    

   # 'vagrant' as alias for the host
   Host vagrant
     # Values from vagrant ssh-config
     HostName 127.0.0.1
     User vagrant
     Port 2222
     UserKnownHostsFile /dev/null
     StrictHostKeyChecking no
     PasswordAuthentication no
     IdentityFile $HOME/.vagrant.d/insecure_private_key
     IdentitiesOnly yes
     LogLevel FATAL

3. SequelPro setup
   • Use SSH connection type
   • MySQL Host: 127.0.0.1
   • Username: <MySQL user on VM>
   • Password: <MySQL password on VM>
   • Database: <MySQL database VM>
   • Port: <MySQL port on VM>
   • SSH Host: vagrant
   • SSH User: vagrant