Roots and WP Packages are independent open source projects, supported only by developers like you. We’ve been improving the WordPress developer experience since 2011, and your support keeps it independent.
WordPress Database Access with Trellis
View as Markdown:
Accessing your databases with client software like Sequel Pro, Sequel Ace and TablePlus is straight forward with trellis-cli. Run the following from any directory within your project:
Sequel Pro (or Sequel Ace):
$ trellis db open --app=sequel-pro production example.com
TablePlus
$ trellis db open --app=tableplus production example.com
SSH Password?
Because Trellis provisions remote environments to use SSH keys rather than passwords, the password field or prompt is left blank.
Connection details
To access database passwords, run:
$ trellis vault view <environment> | grep "db_password"
Remote servers
- Connection type: SSH
- MySQL host:
127.0.0.1 - Username:
example_com - Password:
example_dbpassword - SSH Host:
example.com - SSH User:
web
Last updated
