Varying Vagrant Vagrants logo Varying Vagrant Vagrants

You can work with the database from inside the VM with WP CLI or mysql, and even from PHPMyAdmin, but some users prefer software such as HeidiSQL, or Sequel Pro.

To connect using an external sql client, there are 2 methods:

We’ll be using Sequel Pro to demonstrate, but the same goes for any other software you might prefer to use.

Direct Connections

To do this, you need to connect to the Virtual Machine, not localhost, using the username and password external. This type of connection is useful for PHPStorm.

Field Value
host vvv.test
username external
password external

Leave the database and port fields blank. Here is an screenshot for reference:

A screenshot of Sequel Pro showing direct connection settings

Using an SSH Tunnel

Similar to the Direct connection, choose the SSH option. Then, you will need to tell the software how to SSH into VVV, and the MySQL details to use once it’s inside

Field Value
SSH host vvv.test
SSH username vagrant
SSH password vagrant
MySQL host 127.0.0.1
MySQL username root
MySQL password root

Leave the database and port fields blank.

A screenshot of Sequel Pro showing direct connection settings