Working with Vagrant is a change in term of provisioning your DEV enviroment, but also come with new challenges. Now you database is not a local service anymore. It’s running somewhere deep in the forest of Vagrant and Virtual Box. Arrive there in not easy but not imposible. Using the SSH tunnel we can create a trust channel to see into vagrant.

Here is my challenge (Basically I’m writing this for myself in the future)

I need to connect SEQUEL PRO to a MySql instance runnign in a vagrant machine.

The vagrant is an Ubuntu 12.04 image with MySQL installed.

1) Connect to your vagrant :

$vagrant ssh

2) Find the address MySQL is bound to :

cat /etc/mysql/my.cnf | grep bind-address bind-address = 99.99.99.99 <- example

3) enter to your

mysql root -r root -p {root-password-here}

4) Running inside of MYSQL

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'{99.99.99.99}' IDENTIFIED BY '{root-password-here}' WITH GRANT OPTION; 
FLUSH PRIVILEGES;

5) return to your host system

6) open SEQUEL PRO

7) Go to SSH connections :

* Name: <anyname>
* MySQL Host: {99.99.99.99}  (MySql IP from step 2)
* Username: root
* Password: {root-password-here}
* Database: {database-name}
* Port: 3306
* SSH Host: 127.0.0.1
* SSH User: vagrant
* SSH Key: ~/.vagrant.d/insecure_private_key
* SSH Port: 2222 (or 2200, depend on the vagran up result)

8) Test connection, Save Configuration …

Connect

General ideas from Connect to MySQL in Vagrant with Sequel Pro

If you have any question following the steps, please add a comment.