PDOException SQLSTATE[HY000] [2002] No such file o

Question

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as php artisan migrate or php artisan db:seed) I get an error message:

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

At some point the migration must have worked, because my tables are there - but this doesn't explain why it isn't working for me now.

Answer 1

In may case, I'd simply used

vagrant up

instead of

homestead up

for my forge larval setup using homestead. I'm assuming this meant the site was getting served, but the MySQL server wasn't ever booted. When I used the latter command to launch my vagrant box, the error went away.

Answer 2

All these answers seem like heavy lifting...

I just created a .env file; edited my bootstrap/app.php file, and uncommented the following line...

Dotenv::load(__DIR__.'/../');

Hope this helps someone

Answer 3

This is because PDO treats "localhost" host specially:

Note: Unix only: When the host name is set to "localhost", then the connection to the server is made thru a domain socket. If PDO_MYSQL is compiled against libmysqlclient then the location of the socket file is at libmysqlclient's compiled in location. If PDO_MYSQL is compiled against mysqlnd a default socket can be set thru the pdo_mysql.default_socket setting.

(from http://php.net/manual/en/ref.pdo-mysql.connection.php)

Changing localhost to 127.0.0.1 will "force" the use of TCP.

Note: mysqli_connect is working fine with localhost.

Answer 4

The error message indicates that a MySQL connection via socket is tried (which is not supported).

In the context of Laravel (artisan), you probably want to use a different / the correct environment. Eg: php artisan migrate --env=production (or whatever environment). See here.

Answer 5

I got the same problem and I'm running Mac OS X 10.10 Yosemite. I have enabled the Apache Server and PHP that already comes with the OS. Then I just configured the mCrypt library to get started. After that when I was working with models and DB I got the error:

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

The reason I found is just because PHP and MySQL can't get connected themselves. To get this problem fixed, I follow the next steps:

1. Open a terminal and connect to the mysql with:

   mysql -u root -p
   

2. It will ask you for the related password. Then once you get the mysql promt type the next command:

   mysql> show variables like '%sock%'
   

3. You will get something like this:

   +-----------------------------------------+-----------------+
   | Variable_name                           | Value           |
   +-----------------------------------------+-----------------+
   | performance_schema_max_socket_classes   | 10              |
   | performance_schema_max_socket_instances | 322             |
   | socket                                  | /tmp/mysql.sock |
   +-----------------------------------------+-----------------+
   

4. Keep the value of the last row:

   /tmp/mysql.sock
   

5. In your laravel project folder, look for the database.php file there is where you configure the DB connection parameters. In the mysql section add the next line at the end:

   'unix_socket' => '/tmp/mysql.sock'
   

6. You must have something like this:

   'mysql' => array(
           'driver'    => 'mysql',
           'host'      => 'localhost',
           'database'  => 'SchoolBoard',
           'username'  => 'root',
           'password'  => 'venturaa',
           'charset'   => 'utf8',
           'collation' => 'utf8_unicode_ci',
           'prefix'    => '',
           'unix_socket' => '/tmp/mysql.sock',
       ),
   

Now just save changes, and reload the page and it must work!

Answer 6

Mamp user enable option Allow network access to MYSQL