# Settings for local Vagrant SSH connection with Sequel Pro

**URL:** https://discourse.roots.io/t/settings-for-local-vagrant-ssh-connection-with-sequel-pro/11966
**Category:** trellis
**Created:** 2018-03-20T17:05:05Z
**Posts:** 8

## Post 1 by @richt — 2018-03-20T17:05:05Z

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](https://discourse.roots.io/uploads/default/original/2X/2/2c4b542cb541a276aa23723cb95f56709ab54df7.png)

Here is my wordpress\_sites file

wordpress\_sites:  
[relaxva.co.uk](http://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](mailto:richard@dandelionsocial.com)  
multisite:  
enabled: false  
ssl:  
enabled: false  
provider: self-signed  
cache:  
enabled: false

Am I doing something really obvious wrong?

---

## Post 2 by @kalenjohnson — 2018-03-20T17:09:40Z

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](https://coderwall.com/p/etzdmq/get-vagrant-box-guest-ip-from-host)

---

## Post 3 by @richt — 2018-03-20T17:13:47Z

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

---

## Post 4 by @richt — 2018-03-20T17:23:03Z

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](https://discourse.roots.io/uploads/default/original/2X/a/ababbfc0cc5604cfd8b113f04b5bcb4ed0273a35.png)

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?

---

## Post 5 by @kalenjohnson — 2018-03-20T17:30:40Z

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

---

## Post 6 by @richt — 2018-03-20T17:35:11Z

Back to square one then!

---

## Post 7 by @fullyint — 2018-03-20T18:52:23Z

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

---

## Post 8 by @richt — 2018-03-20T18:56:40Z

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.