ramblings about cars, tech, web development and more. BOTB Winner in 2010

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!

Previous

Posting a form in WordPress sends you to a 404 page

Next

Adding days to a date in Excel

5 Comments

  1. Tuomo

    Vagrant’s SSH password seems to be “vagrant”, not “secret”. Thank you though! 🙂

  2. Ahmad Moussa

    Thank you finally it worked after following your tutorial

  3. Adam

    Thank you. That was super easy.

  4. 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!

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.

Powered by WordPress & Theme by Anders Norén