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 :)

 

About 

Hi, I'm a Berlin-based developer and working on webstuff since 2000. My focus lies on PHP, TYPO3 and Symfony. 2009 I became a certified TYPO3-Integrator. I worked on projects for clients like Paypal, Union Investment, Commerzbank or Warsteiner.

Go check out my page http://www.christian-baer.com

Published by

Christian Baer

Hi, I'm a Berlin-based developer and working on webstuff since 2000. My focus lies on PHP, TYPO3 and Symfony. 2009 I became a certified TYPO3-Integrator. I worked on projects for clients like Paypal, Union Investment, Commerzbank or Warsteiner. Go check out my page http://www.christian-baer.com

One thought on “Connect remote vagrant mysql-db via Navicat”

  1. Thank you! Exactly what I was looking for. I would never have figured out what to put in each of those fields if I had to figure out on my own! Vagrant is really nice, but it sure makes you have to relearn a lot. :)

    -Mike

Leave a Reply to Mike Schinkel Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">