Settings for local Vagrant SSH connection with Sequel Pro

trellis
1

Hi guys, I’ve read through the discourse topics as best I can for similar issues and have tried most of them with no luck. I am trying to connect to my local MySQL database with Sequel Pro but am getting a permission denied error. I’m not sure if my settings are correct.

22
222854×1414 1.15 MB

Here is my wordpress_sites file

wordpress_sites:
relaxva.co.uk:
site_hosts:
- canonical: relaxva.local
local_path: …/site # path targeting local Bedrock site directory (relative to Ansible root)
admin_email: richard@dandelionsocial.com
multisite:
enabled: false
ssl:
enabled: false
provider: self-signed
cache:
enabled: false

Am I doing something really obvious wrong?

2

It seems like you’re trying to SSH to your local host (127.0.0.1), that’s not going to work. Need to SSH to your Vagrant box.

You can get the IP Address like this: https://coderwall.com/p/etzdmq/get-vagrant-box-guest-ip-from-host

3

Hey Kalen, I’m using the settings as laid out here https://roots.io/trellis/docs/database-access/

4

Well this is interesting. I didn’t understand the info in the coderwall link (I’m still a newbie to this stuff) but I found (I think the IP of the Vagrant box inside vagrant.default.yml so I tried that and got the below.

19
192252×1552 413 KB

This seems to be telling me it’s found the DB but won’t let the SSH host connect for some reason. Note that the roots documentation suggests the SSH host should be example**.test** but I’m assuming (I know, dangerous) that this is on the understanding that a local dev environment would use this domain. I am using .local and not .test (as in my wordpress_sites file) hence why I have changed it or am I wrong here?

Anyone have any further thoughts?

5

Whoops, my bad, it’s been quite a few years since I used Sequel Pro. Should be correct in that you used the local URL in SSH Host.

6

Back to square one then!

7

@richt The settings in your original screenshot look good except…

SSH Port. Will you run vagrant ssh-config | grep Port in your trellis directory? Add that port to the “SSH Port” field at bottom of Sequel Pro window.

Username. Also try changing relaxva_co.uk to relaxva_co_uk then attempt the connection again.

8

Hiya, I delved a little into the .env file and noticed that relaxva_co.uk was set to relaxva_co_uk so I changed that in Sequel Pro and voila!

Thank you for your help and thank you for all the time and effort you’ve put into the Roots project. I’m new to serious WP development and it’s certainly been a steep learning curve but I’m super excited about making this my default workflow.

2 Likes