Laravel PHPUnit PDOException exception

Question

I don't know why when I run a PHPUnit test, I get the following error:

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

My testing environment database setting is:

return [

    'fetch' => PDO::FETCH_CLASS,

    'default' => 'mysql',

    'connections' => [
        'mysql' => [
            'driver'    => 'mysql',
            'host'      => 'localhost',
            'database'  => 'clg_test',
            'username'  => 'root',
            'password'  => 'veryHardPass',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ]
    ],

    'migrations' => 'migrations',

];

The reason why I am using MySQL as oppose to SQLite is because my migration files use dropColumn which is not supported by SQLite. I call the migration via Artisan::call('migrate') in the setup.

If I actually call migration manually in the terminal via php artisan migrate --env=testing then the migration IS successful and the databases are created.

Why am I then facing the above problem?

Joel Hinz · Accepted Answer · 2014-12-09 21:35:51Z

3

Try changing localhost to 127.0.0.1. The message you're getting is indicative of the script not being able to connect to MySQL through a socket, but using an ip should work.

answered Dec 9, 2014 at 21:35

Joel Hinz

25.4k8 gold badges65 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kousha Over a year ago

Thanks, so now I am getting a connection refused error!

Joel Hinz Over a year ago

Well, that's a start... :) unfortunately, I don't know what might cause that. I hope you find the error.

Collectives™ on Stack Overflow

Laravel PHPUnit PDOException exception

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related