I have created a new Laravel project in Laravel 8. I have set up Sail installation correctly, everything working fine for the database connection locally but when I try to connect my database using Sail it gives me an error
SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel8 and table_name = migrations and table_type = 'BASE TABLE')
I have already cleared my config and cache files.
I was researching the same problem and found this.
The code shows an artisan command added by laravel sail - sail:install which overwrites your .env file host variables with service names.
I changed DB_HOST from 127.0.0.1 to mysql and it was fixed
Edit to answer questions:
Sail is based on Docker, to establish a connection between two Docker containers on the same Docker network, you can reference the container by its name, and Docker will handle the resolution for you.
This is why we use mysql instead of the address
sail down -v do remove the stored mysql volume with the wrong config and sail up -d to rebuild. After that it worked.
DB_HOST=mariadb in my .env file and container_name: mariadb in the docker-compose.yml .On cmd just run this command
docker network inspect bridge
You will get response like (similar) this:
[
{
"Name": "bridge",
"Id": "695c284c7b184839edf97d48161922dfe6c4827d0db917c3278f5634af7e00e2",
"Created": "2022-02-22T22:17:30.8583513Z",
"Scope": "local",
"Driver": "bridge",
"EnableIPv6": false,
"IPAM": {
"Driver": "default",
"Options": null,
"Config": [
{
"Subnet": "172.17.0.0/16",
"Gateway": "172.17.0.1"
}
]
},
.....
}
]
Copy "Gateway" ip address and replace with DB_HOST value in .env file. It will work
mysql value stops working?
if you want run mysql in different port for example 3307 like below
ports:
- 3307:3306
you should add FORWARD_DB_PORT environment variable to .env file like this
DB_PORT=3306 // this is for container port
FORWARD_DB_PORT=3307 // this is for local port
Changing DB_USERNAME from sail to root worked for me. I guess sail did not have the required privileges.
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=database
DB_USERNAME=root # changed from sail
DB_PASSWORD=password
Maybe you should match the environment variables of .env.testing, since, as willpercey-gb says, the sail:install command updates the environment variables of .env, but not of .env.testing.
I had this same issue after creating a second sail project in my docker. It wasn't (still isn't) accepting the sail username or password but I could go in with root which gave me the error you gave above. I went to the Desktop Docker app, clicked the running container, found the mysql portion and ran the CLI, typed mysql and then ran the query CREATE DATABASE yourdatabasename; migration ran perfectly fine.
First off stop all services using brew especially MySQL
brew services stop MySQL
in your docker-yaml file:
laravel.test
ports:
- '70:80'
mysql:
ports:
- '3456:3306'
Now run your sail artisan migrate command.
this should solve your problem.
