I followed the instructions here to connect to a site’s production db through Sequel Pro and it worked as expected on my machine. I passed off the instructions to my colleague to provide them access, and they received the following error:
SSH connection failed!
The SSH Tunnel could not authenticate with the remote host. Please check your password and ensure you still have access.
My guess is it’s because they don’t have an SSH key set up in trellis / digital ocean. Can somebody please confirm that this is the issue i’m having, and help me understand how to resolve it?
Thanks.
P.S. My colleague doesn’t need the ability to provision or deploy anything… They only need to access the db.
Unless there’s a really good reason to do so, I wouldn’t worry too much about them having the ability to deploy in addition to database access. I assume if you’re giving the person access to your db then you have a pretty high degree of trust in the person.