Connect Your Sequel Pro with Laravel Homestead

Laravel Homestead is a vagrant box created by Taylor Otwell to mimic production environment locally. It’s a very awesome tool for developing Laravel applications. Most PHP developers are used to just using PHPMyAdmin to connect to their MySQL databases meanwhile Sequel Pro is also a very good tool for connecting to your MySQL database.

Once you have initiated your homestead using vagrant up, Connect Your Sequel Pro with Laravel homestead by doing this:

1. Fire up your Sequel Pro

2. Choose Standard

3. Put in your credentials as stated below:

Host: 127.0.0.1

Username: homestead

Password: secret

Database: That is very optional, you don’t need to put that

Port: 33060

4. Click Connect

That’s all

If you have any challenges still connecting to your homestead database, please let me know in the comments section.

About the Author
Latest Posts

About PROSPER OTEMUYIWA

Food Ninja, Code Slinger, Technical Trainer, Accidental Writer, Open Source Advocate and Developer Evangelist.

How to build your own Youtube – Part 10 - August 1, 2016
How to build your own Youtube – Part 9 - July 25, 2016
How to build your own Youtube – Part 8 - July 23, 2016
How to build your own Youtube – Part 6 - July 6, 2016
Introducing Laravel Password v1.0 - July 3, 2016
How to build your own Youtube – Part 5 - June 28, 2016
How to build your own Youtube – Part 4 - June 23, 2016
How to build your own Youtube – Part 3 - June 15, 2016
How to build your own Youtube – Part 2 - June 8, 2016
How to build your own Youtube – Part 1 - June 1, 2016

sirolad

A note to users is that for now, Sequel Pro is only available to Mac OS , Windows User can make use of HeidiSQL while Linux users have an alternative in Dbeaver. Enjoy!
Shane

I cant get this to work, I’m constantly getting the error below
- Prosper
  
  Hi @shaneparsons1:disqus The reason you are getting that error is because you haven’t spun up a MYSQL Server yet. You either need to start MySQL manually from your terminal or start the service from a GUI application before you can now connect to it using Sequel Pro.
  
  Are you using laravel homestead?
  - Shane
    
    I currently have MySQL running and am able to connect to it through the terminal when SSH’d into homestead, however that doesn’t seem to solve my problem.
    
    I believe I am using Homestead 2.1.7 by the way.
    - Prosper
      
      Mac, Windows or Ubuntu..Which are you using? because Sequelpro can’t seem to find the instance of laravel homestead mysql server
      - Shane
        
        Im using Mac
      - Prosper
        
        So try destroying your vagrant box. Then run vagrant up again .
      - Shane
        
        I’ve tried that many times already, all leading to the same result.. I even went as far as un-installing / re-installing vagrant and homestead.
      - Prosper
        
        Have you tried using IP 192.168.10.10 that comes with your Homestead.yaml file?
      - Shane
        
        Yes sir, exact same error
      - Prosper
        
        I wish we could pair on screenhero. There might be something little you omitted somewhere.
      - Shane
        
        There was a recent update to the 2.1.7 vagrant box, and everything seems to be working fine now.. I think the previous version of 2.1.7 had some issues.
      - Prosper
        
        Awesome..Great!

Goodheads

Connect Your Sequel Pro with Laravel Homestead

About PROSPER OTEMUYIWA

Getting Started With Testing in Laravel

How To Create Custom Helper Functions in Laravel 5