Database Access

Accessing your databases with tools such as Sequel Pro and MySQL Workbench just requires some initial configuration.

Development (Vagrant box)

  • Connection type: SSH
  • MySQL host: 127.0.0.1
  • Username: example_com
  • Password: example_dbpassword (use the value of db_password from group_vars/development/vault.yml)
  • SSH Host: example.test
  • SSH User: vagrant
  • SSH Key: Select the following file from your Trellis directory: .vagrant/machines/default/virtualbox/private_key

Remote servers

  • Connection type: SSH
  • MySQL host: 127.0.0.1
  • Username: example_com
  • Password: example_dbpassword (use the value of db_password from group_vars/<environment>/vault.yml)
  • SSH Host: example.com
  • SSH User: web

Join over 5,600 subscribers on our newsletter to get the latest Roots updates, along with occasional tips on building better WordPress sites.

Looking for WordPress plugin recommendations, the newest modern WordPress projects, and general web development tips and articles?

“Easily the best WordPress email I get.” Colin OBrien

Ready to checkout?