skip to Main Content

I am using Laravel Sail/ Docker for the first time. I have got my site running fine but the issue is that I cannot access the DB via a GUI (Sequel Pro). I have added the default credentials from my env but cannot access. But seem to be able to run php artisan migrate. Does anybody have any tips for how I can debug this?

This is my .env file:

DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=my-db
DB_USERNAME=sail
DB_PASSWORD=password

2

Answers


  1. The solution for you might be in the last comment here by Lorenzo Franzone: changing the SequelPro version.

    Rather than this though, I dropped the version of MySQL in docker-compose from 8.0 to 5.7 to work with my very old version of SQLYog and: Bingo! It worked.

    Login or Signup to reply.
  2. Simple, you must change DB_HOST=mysql to DB_HOST=127.0.0.1
    Have a good day.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search