How to connect to you database using Vagrant
As you may or may not know, I started to really use vagrant lately. The installation process to get a PHP development environment is quite easy. However, there was a few moment were I run into a small issues. Most of them happened just because my mind was still programmed to work with a simple Lamp stack.
One of the issues that made me lose 20 minutes or so was connecting SequelPro to the database. Sure I installed PHPmyAdmin but I wanted to use my own database management app.
All you need to do is create a SSH tunnel to your server. Todo so, you need to use the following settings.
Server name: "YourServerName" (doesn't really matter)
MySQL Host: 127.0.0.1
Username: root
Password: ******
Database:
Port:
SSH Host: 192.168.56.101
SSH User: vagrant
SSH Password: vagrant (this is the default one)
SSD Port:
Your first impulse might be to connect using the virtual machine IP as your normal host like I did, but that obviously will not work. Also, took me a while to find out the SSH password, but that happened mostly because I was reading the documentation while I was using it.