Connect remote vagrant mysql-db via Navicat

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]

Navicat connection

 Tab “SSH”

  • hostname: your local domain / url, alternatively the IP-address (192.168.50.x)
  • port: default
  • username: vagrant
  • password: vagrant

Navicat SSH-Tunnel

 

That’s it :)