# Web User Password for Sequel Remote Connection

**URL:** https://discourse.roots.io/t/web-user-password-for-sequel-remote-connection/20193
**Category:** trellis
**Tags:** trellis-cli
**Created:** 2021-02-24T20:39:04Z
**Posts:** 9

## Post 1 by @mZoo — 2021-02-24T20:39:04Z

Looking at the [Trellis docs](https://roots.io/docs/trellis/master/database-access/#development-vagrant-box) and also [Trellis-cli code](https://github.com/roots/trellis-cli/blob/7c914d630434df0c13e2947b603e1c58eb9bc7f1/cmd/db_opener_sequel_pro.go), it looks like I need to have configured an SSH password for the `web` user on the server.

Is that something that the case? Is that

1. Not accurate
2. Something I should do manually
3. Something I should do via Trellis
4. Built into Trellis

Thanks.

---

## Post 2 by @MWDelaney — 2021-02-24T20:59:27Z

_Could_ you do it with keys instead of a password?

---

## Post 3 by @mZoo — 2021-02-24T21:42:23Z

In theory. I would just leave the password field blank in Sequel Pro? Wait, it looks like my key is already there for the web user:

```
users:
  - name: "{{ web_user }}"
    groups:
      - "{{ web_group }}"
    keys:
      - "{{ lookup('file', '~/.ssh/id_rsa.pub') }}"
```

Right?

---

## Post 4 by @MWDelaney — 2021-02-24T21:45:35Z

Yes, if you provisioned the site from your machine, you should be able to connect with just a username (and Sequel Pro will provide your key automatically).

---

## Post 5 by @mZoo — 2021-02-24T21:46:24Z

The error I’m getting when I try to connect that way is:

```
Used command: /usr/bin/ssh -v -N -o ControlMaster=no -o \
ExitOnForwardFailure=yes -o ConnectTimeout=10 -o \
NumberOfPasswordPrompts=3 -o TCPKeepAlive=no -o \
ServerAliveInterval=60 -o ServerAliveCountMax=1 -p 22 \
web@134.xxx.xxx.xxx -L 50297/127.0.0.1/3306

Bad local forwarding specification ' 50297/127.0.0.1/3306'
```

---

## Post 6 by @mZoo — 2021-02-24T21:55:48Z

It was a [Sequel Pro bug](https://github.com/sequelpro/sequelpro/issues/2253), combined with my inexperience with the feature.

Reinstalled Sequel Pro (update was failing) and working now. Thanks.

---

## Post 7 by @MWDelaney — 2021-02-24T21:57:55Z

Sorry, man, I tried to dash off a quick answer without testing it.

This worked for me:

 ![image](https://discourse.roots.io/uploads/default/original/2X/9/9b83e412f3c22168abd164741cf185b5b67a2839.jpeg)

**MySQL**  
MySQL Host: `127.0.0.1`  
Username: `root`  
Password: `[found in Trellis vault for the specific environment]`

**SSH**  
SSH Host: `example.com`  
SSH User: `web`  
SSH Key: `[browse to your public key locally]`

In case anyone else needs this info in the future!

---

## Post 8 by @mZoo — 2021-02-24T22:05:34Z

Beautiful. Thank you. I didn’t need to even specify the SSH Key. Also hadn’t realized the “key” icon was a toggle button.

---

## Post 9 by @MWDelaney — 2021-02-24T22:09:38Z

> [@mZoo](#):
>
> Also hadn’t realized the “key” icon was a toggle button.

Yeah. Sequel Pro isn’t super famous for its UX.

In related news, apparently [Sequel Ace](https://sequel-ace.com) is a maintained fork of Sequel Pro.

Or if you’re willing to pay for quality [TablePlus](https://tableplus.com) is just gorgeous.