Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel 5.1 - Homestead MySQL connection. `Connection Refused` & `No such file or directory`

When my .env file is like this:

 DB_HOST=127.0.0.1
 DB_DATABASE=homestead
 DB_USERNAME=homestead
 DB_PASSWORD=secret

Terminal php artisan migrate works successful but on localhost test, it throws:

PDOException in Connector.php line 50:

SQLSTATE[HY000] [2002] Connection refused

But when my .env file is like this:

 DB_HOST=localhost
 DB_DATABASE=homestead
 DB_USERNAME=homestead
 DB_PASSWORD=secret

On localhost everything (registration) works well however php artisan migrate on terminal throws:

[PDOException] SQLSTATE[HY000] [2002] No such file or directory

My database.php file:

      'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'homestead'),
        'username'  => env('DB_USERNAME', 'homestead'),
        'password'  => env('DB_PASSWORD', 'secret'),
        'port'      => '33060',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],
like image 381
senty Avatar asked Mar 15 '23 03:03

senty


1 Answers

Inside the VM the sql port is 3306. Outside of the homestead VM the host machine just has a forward to the SQL port on the homestead VM. That is why 33060 points to 3306.

Laravel Homestead Vagrant Box Database Problems

like image 163
nathanmac Avatar answered Mar 18 '23 09:03

nathanmac