VVV logo VVV

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 Ace.

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

There are also some client specific methods available:

Any client you use should be able to use the details listedunder direct connections. We’ll be using Sequel Ace to demonstrate, but the same goes for any other software you might prefer to use.

Direct Connections

These details can be used with any SQL client. 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
port 3306
username external
password external

Leave the database field blank. If asked for a database type, choose MariaDB, or MySQL if that isn’t an option.

Here is an screenshot from Sequel Pro/Ace for reference:

A screenshot of Sequel Pro showing direct connection settings

Beekeper Studio import URL

Click on import from URL and enter mariadb://external@vvv.test:3306 then click import. You should now click on connect, and select a database in the top left dropdown.

For more information about Beekeeper Studio, click here.

TablePlus URL

Add a new connection, and import this URL: mariadb://external:external@vvv.test

Predefined Sequel Pro/Ace Config

A saved config file can be found at database/sequelpro.spf, importing this file into Sequel Pro or Sequel Ace will configure a database connection automatically.

The VVV team recommend Sequel Ace over Sequel Pro

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.

Note that a direct connection is often easier and simpler to configure.

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

Leave the database and port fields blank.

A screenshot of Sequel Pro showing direct connection settings