Homestead - Connecting to my database

mysql laravel homestead
Nicolas picture Nicolas · Jul 28, 2016 · Viewed 20.3k times · Source

I just created a fresh laravel project and I'm using a Homestead vagrant box by running

vagrant init laravel/homestead

and after

Vagrant Up

When I use vagrant ssh it gives me no problem and I can acces the vagrant box, however when I want to connect to the DB with Heidisql I get a connection error:

can't connect to mysql server on 'localhost' (10061)

Here's my setup

enter image description here enter image description here

the password I'm using = "secret"

Answer

Dami picture Dami · Aug 20, 2018

The usual credentials/info you need:

  • IP address 192.168.10.10 (Check your Homestead Folder>Homestead.yaml)
  • Port: 3306
  • User: homestead (all lowercase)
  • Pw: secret

Related questions

Laravel; "SQLSTATE[HY000] [2002] Connection refused"

I set up homestead 2.0 on OSX host and using Sequel Pro. I can do migration and confirm that data are migrated in Sequel Pro, so it looks like no problem about DB connection. But once I try to fetch data …

Read More
PDOException SQLSTATE[HY000] [2002] No such file or directory

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as php artisan migrate or php artisan db:seed) I get an error message: [PDOException] …

Read More
How to do this in Laravel, subquery where in

How can I make this query in Laravel: SELECT `p`.`id`, `p`.`name`, `p`.`img`, `p`.`safe_name`, `p`.`sku`, `p`.`productstatusid` FROM `products` p WHERE `p`.`id` IN ( SELECT `product_id` FROM `product_category` WHERE `category_id` IN ('223…

Read More