Here’s what seems to work all in one place:
Some things to note:
- The name at the top is just the name of your connection favorite, so name it something that won’t be confusing later (the thing to remember is it’s not part of the connection and it should make sense when you come in later and want to use the favorite)
- sometimes when you clikd the “SSH” tab in sequel pro, it doesn’t show the whole form, you need to toggle between tabs to make it show the whole form (at least for me)
- use the database username and password that’s in your wordpress_sites.yml file
- the database name is also in the wordpress_sites.yml file, but it’s optional. You can select a database in sequel pro with the dropdown menu after you connect if you want
- the ssh key that worked for me was to click the blue key button and navigate to yoursite.com > .vagrant > machines > default > virtualbox > private_key
- I had a problem with the ssh connection and I went into .ssh/known_hosts and deleted the row for 127.0.0.1. I used sudo. I used nano, locate the line and use Ctrl + K to delete the line.