My favorite mysql-client for Mac is Navicat, mostly because of its synchronizing feature. So when you want to connect your local vagrant-mysql-db, you have to use a SSH-Tunnel:
Tab “General”
- hostname: localhost
- port: default (3306)
- username: root
- password: [password you set up in your vagrantfile / puppet-settings]
Tab “SSH”
- hostname: your local domain / url, alternatively the IP-address (192.168.50.x)
- port: default
- username: vagrant
- password: vagrant
That’s it