Connect a db-visualization program to db using homestead on win

I have everything up and running nicely on my windows machine. I do homestead and VM. My database is all there and i can log on to it in the terminal. But as the tutorial says I want a db visualization program. Jeff is suggesting sequelPro but it is only for mac... I have looked around and found DBeaver to look really good. So I am good there. Now to my problem:

I am trying to connect with the data from the .env file: DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=blog

DB_USERNAME=root

DB_PASSWORD=secret

This is from DBeaver: http://i.imgur.com/syoAMcQ.png

Don't know which local client thats right but I have tried them all and nothing works. Get this when I connect: http://i.imgur.com/ibWmk9j.jpg

Does anyone know what is wrong?

nita.rayan

8 years ago

Level 1

Oh, I have the similar one, please help(

Cronix

8 years ago

Best Answer

Level 67

You're trying to connect to the wrong port. port 3306 from WITHIN homestead (like your laravel app), port 33060 to connect remotely from OUTSIDE homestead (your host OS - windows).

To connect to your MySQL or Postgres database from your host machine's database client, you should connect to 127.0.0.1 and port 33060 (MySQL) or 54320 (Postgres). The username and password for both databases is homestead / secret.

https://laravel.com/docs/5.4/homestead#connecting-to-databases

1 like

Please or to participate in this conversation.