Laravel Homestead is now out, and I love using it for my Vagrant environment. That being said, sometimes configuration of third-party tools like Sequel Pro can be a bit funny.
Connecting Sequel Pro to Laravel Homestead is pretty easy. The @laravelphp Twitter account posted a tweet on May 16, 2014 that outlined how to do this by default, but sometimes tweets are hard to find, so I wanted to put it in plain text and post the image here as well so it can be Googl-ified.
Once you have Homestead set up and you have run “vagrant up” just…
- Choose “Standard” toggle at the top
- Put in the following credentials
- Name: Homestead
- Host: 127.0.0.1
- Username: homestead
- Password: secret
- Database: (optional, whatever you want if you want to directly connect)
- Port: 33060
Happy Homesteading!
Comments
46 responses to “Using Sequel Pro with Laravel Homestead”
Thanks for posting this! Worked like a charm.
This does not work for me. Running fresh installation of homestead
Hey “Guest” 😉 – it looks like you are using port 3306 which is the default port for MySQL. You need to use port 33060 – which is what Laravel Homestead uses so it does not conflict. Let me know if that helps!
This does not work for me
Hey Mattias, Homestead 2.0 was just released 2-3 weeks ago, so be aware of that. However, I just installed v2.0 a few days ago and this setup worked great like it did before.
Is there anything specific that you can share about what is failing?
Make sure you are using the correct port. 33060 (not 3306 which is default)
I did not know it was so simple! Thanks Tanner!
No problemo!
Thanks!
thanks!
Thanks for this post! it worked easily
Haha I tried so many different things in my search to get this working. Thank you for posting this. it helped a lot!
No problem!
Thank you so much!
Thanks a log Tanner (y) keep it up
I can’t get this to work either.. I’ve tried everything include re-installing vagrant and homestead, but all I get is this error message.
Hey @shaneparsons1:disqus – are you sure Homestead is running?
Assuming you mean via `vagrant up`, yes it is.
I believe I’m running Homestead 2.1.7 if that helps at all..
Hm…I think you may need to use the actual `homestead up` command. There are also some setup things to make sure you have ready that you can do by running `homestead init`
See the attached image.
Im curious as to why the official homestead documentation, http://laravel.com/docs/5.1/homestead, mentions nothing about `homestead up`..
I’ve done all the setup accordingly as well, which is leading me to believe that 2.1.7 has some issues.
Have you successfully managed to do it with 2.1.7?
I am on 2.1.6 – I’ll try and upgrade and test it soon and get back with you.
There was a recent update to the 2.1.7 vagrant box, and everything seems to be working fine now.
It is working perfect! Thanks!
Thanks!
Works like a charm
Perfect! Glad I could help!
Thank you for taking the time to put this together, got it up and running in a couple of mins. 🙂
Awesome! Glad to help 🙂
That didn’t work for me.
Hey JV – what is it doing? Just erroring out?
Hey @jv_krakowski:disqus – what did it do for you? Did it throw any specific error? I’ve used this tactic for two years (and am using it right now as I write this). Would be curious if you have any specifics on what may be causing it not to work.
I have yet to access the database at all.
Hm…can you share a screenshot?
Awesome! This worked for me. Thanks.
Sure thing @dannamite:disqus!
Thanks, it works
No problem @disqus_eAEhJggo3Z:disqus !
I can’t get this to work. I keep getting an error saying MySQL said: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
Hm…I haven’t encountered that before @brian_rivet:disqus. Do you think it has to deal with your Homestead setup or MySQL connection?
Hi Tanner. Turns out it was a provisioning issue. I reloaded and reprovisioned and it kicked right on. Thanks!
Awesome! Glad to hear it!
Hi Tanner, it looks like I may have spoke too soon. I am able to connect via Sequel Pro, but I’m having a problem where mysql won’t stay up and running for more than about a minute. When I ssh into Homestead and try to restart mysql it times out. Have you ever heard of this issue? I saw a thread saying it was an issue with Apparmor in Ubuntu but I followed the directions to fix it and it still won’t start up.
Hm…that seems like a MySQL issue, but Homestead should work out of the box. Have you tried reinstalling Homestead?
I was able to sort it out. Or at least get it working. It looks like there is some sort of an issue with apparmor in the version of ubuntu that is in Homestead. It kills mysql after a few minutes and blocks it from restarting. I found a script to add to the after.sh that dialed back apparmor’s mysql setting to complain mode instead of enforce.
Awesome! Glad you worked it out!
Thank you so much, it works… but why? lol
Thought I must connect to Vagrant’s SQL via SSH tunnel instead of just direct connect? hmmmm