Laravel Sail connection refused with MySQL on localhost

Asked Mar 02 '23 at 17:52

Active Mar 07 '23 at 19:37

Viewed 350 times

When I try to access via Laravel Sail in my local environment using Tinker, I get this error from MySQL:

SQLSTATE[HY000] [2002] Connection refused (SQL: select count(*) as aggregate from users...

Same thing (with an error) if I try to use MySQL Docker.

edited Mar 07 '23 at 19:37

Karl Hill

asked Mar 02 '23 at 17:52

Please add some details like your Laravel version and env vars of DB – A.Seddighi Mar 02 '23 at 20:11
Laravel Framework 8.83.27. The ENV vars for DB are : DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=db_test DB_USERNAME=root DB_PASSWORD=xxx – Antonio Giampetruzzi Mar 03 '23 at 10:01
With Laravel Sail and a MySQL container the DB_HOST is NOT `127.0.0.1`. Check service name in `docker-compose.yml` – UnderDog May 05 '23 at 14:37
for sail, the DB_HOST needs to be "mysql" -> https://laravel.com/docs/8.x/sail – Eduardo Chongkan Aug 28 '23 at 18:49

0 Answers0