- In my experience the best way to connect SequelPro on a Mac to a Homestead Vagrant MySQL database is via SSH.
Although you can run multiple apps per vagrant box I’ve always been happier running Homestead in the Per Project mode. It keeps things neat and tidy for me. I’ve also found with more complex setups that Laravel Valet doesn’t always work as intended.
Using the default passwords the step as are as below. If you start changing your defaults this may not work for you…
Ok, first step is to open SequelPro and create a new connection by clicking the small plus sign in the bottom left.
Next up click the SSH button in the connection window.
Now simply fill in the following details:
- MySQL Host
- 127.0.0.1
- Username
- homestead
- Password
- secret
- Database
- homestead
- Port
- Leave empty (3306 as default)
- SSH Host
- 192.168.10.10 (Or whatever you set yours too in your Homestead.yaml file)
- SSH User
- vagrant
- SSH Password
- secret
- SSH Port
- Leave empty
- Connect using SSL checkbox
- Leave empty
Now click Test Connection.
You will be asked if you want to trust the SSH server. Choose Yes and you are good to go!
Tuomo
Vagrant’s SSH password seems to be “vagrant”, not “secret”. Thank you though! 🙂
Ahmad Moussa
Thank you finally it worked after following your tutorial
Adam
Thank you. That was super easy.
Peter
Rembember, if you had previous Vagrant instance and you connected via SSH key, it added it’s SSH key into the known hosts file: ~/.ssh/known_hosts
You will have to delete this file in order for it to work.
Chuck
This comment from Peter saved my butt – wouldn’t connect until deleting the previous line in ~/.ssh/known_hosts file. Thanks!