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:
- SSH tunnel
We’ll be using Sequel Pro to demonstrate, but the same goes for any other software you might prefer to use.
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.
Leave the database and port fields blank. Here is an screenshot for reference:
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
Leave the database and port fields blank.