SQLSTATE[HY000] [2002] Connection refused in laravel

Question

i have this problem with laravel, this is my .env file:

APP_NAME=Laravel
APP_ENV=local
APP_KEY=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
APP_DEBUG=true
APP_URL=
LOG_CHANNEL=stack

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=my_db_name
DB_USERNAME=root
DB_PASSWORD=

and this is my config/database

'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
        ],

i alway get error message SQLSTATE[HY000] [2002] Connection refused, i was changed DB_HOST=127.0.0.1 to DB_HOST=localhost but it's not working.
this is my issue, thanks for help

Try adding DB_PORT = 33060; in .env file also try DB_HOST="localhost" — Vipertecpro, Feb 25 '19 at 11:55
Can you also please provide your OS details and apache details like Xampp or mamp or ngnix ? — Vipertecpro, Feb 25 '19 at 11:57
i try DB_PORT = 33060 and DB_HOST="localhost" but it's not working, my OS is Ubuntu 16.04, i use Xampp — Bách Nguyễn, Feb 26 '19 at 13:34
Can you reinstall the project ? and then try. Also check is port 3306 is used by any other process — Vipertecpro, Feb 27 '19 at 07:47
nahh :v all project laravel error, i think reason is laravel connect mysql, so.... i reinstall ubuntu and .... yep, it run correctly, thanks about your help ! — Bách Nguyễn, Feb 28 '19 at 09:43
Did you tried removing temp files....in windows it's in %temp% folder...idk about ubuntu temp files but it would help — Vipertecpro, Feb 28 '19 at 09:44

score 0 · Answer 1 · answered Mar 04 '19 at 10:41

0

Add APP_URL=http://localhost in .env file.
Hope it will work

answered Mar 04 '19 at 10:41

Chandni Soni

377
4
16

.env file not is problem – Bách Nguyễn Mar 05 '19 at 06:35
yep, i have try – Bách Nguyễn Mar 11 '19 at 02:45

score 0 · Answer 2 · answered Dec 09 '20 at 10:21

0

You need to increase the server ram and the problem will be solved :)

answered Dec 09 '20 at 10:21

Yannick Dirbé

60
7

SQLSTATE[HY000] [2002] Connection refused in laravel

2 Answers2