On Sequel Pro, when you make a "New Connection", use "SSH" tab.

MySQL Host: 127.0.0.1
Username: wordpress
password: wordpress
Port: 3306

SSH Host: 127.0.0.1
SSH User: vagrant
SSH Password: vagrant
SSH Port: 2222