Connect SequelPro to Homestead Vagrant Mysql database

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.

Add a connection to Sequel Pro

Next up click the SSH button in the connection window.

Choose SSH connection type in SequelPro

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!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.