How to fix 'SQLSTATE[HY000] [2002] Connection refused' on creating new database

Asked Jul 22 '19 at 07:21

Active Jul 22 '19 at 07:21

Viewed 137 times

On starting my dockercontainer, I need to create a new db.

Since Laravel doesn't offer a command to create a new database I made my own artisan command (How to create a mysql db with Laravel).

My Custom command:

php artisan make:database newdb

When I execute this command, I get the Error SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

Why do I get this Error? I got this Error in the past when I tried accessing a database which wasn't created yet but now that I am creating a new db I just don't get, why It throws this Error.

Any help would be appreciated

asked Jul 22 '19 at 07:21

carlWheezer

Can you verify the answer in [this post](https://stackoverflow.com/a/2972644/369143)? – Bram Verstraten Jul 22 '19 at 07:26
it looks like a firewall issue to me. – Naktibalda Jul 22 '19 at 07:29
@BramVerstraten I am unable to change any firewall settings because it's managed by my employer and my boss as well as my project manager are on vacation. Is there anything else I could do? – carlWheezer Jul 22 '19 at 07:47
Are you using Fiddler by any chance? – Bram Verstraten Jul 22 '19 at 08:02
Not that I know of – carlWheezer Jul 22 '19 at 08:03
What did you put in your .env file for the DB_* settings? – Bram Verstraten Jul 22 '19 at 08:36
```DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=homestead DB_USERNAME=homestead DB_PASSWORD=secret``` – carlWheezer Jul 22 '19 at 08:43
you need to change the DB_username and DB_Password with correct credentials then run php artisan config:clear – Ghiffari Assamar Jul 22 '19 at 08:50
If you are using Docker on Mac, set `DB_HOST` to `docker.for.mac.host.internal` – Bram Verstraten Jul 22 '19 at 08:56
I'm on Windows 10 – carlWheezer Jul 22 '19 at 08:58
In that case you should use `docker.for.win.host.internal` – Bram Verstraten Jul 22 '19 at 09:13

How to fix 'SQLSTATE[HY000] [2002] Connection refused' on creating new database

0 Answers0