Ошибка sqlstate hy000 2002 no such file or directory

One of simplest reasons for this error is that a MySQL server is not running. So verify that first. In case it’s up, proceed to other recommendations:

Laravel 4: Change «host» in the app/config/database.php file from «localhost» to «127.0.0.1»

Laravel 5+: Change «DB_HOST» in the .env file from «localhost» to «127.0.0.1»

I had the exact same problem. None of the above solutions worked for me. I solved the problem by changing the «host» in the /app/config/database.php file from «localhost» to «127.0.0.1».

Not sure why «localhost» doesn’t work by default but I found this answer in a similar question solved in a symfony2 post. https://stackoverflow.com/a/9251924

Update:
Some people have asked as to why this fix works so I have done a little bit of research into the topic. It seems as though they use different connection types as explained in this post https://stackoverflow.com/a/9715164

The issue that arose here is that «localhost» uses a UNIX socket and can not find the database in the standard directory. However «127.0.0.1» uses TCP (Transmission Control Protocol), which essentially means it runs through the «local internet» on your computer being much more reliable than the UNIX socket in this case.

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.

answered Dec 22, 2013 at 19:08

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!

I encountered the [PDOException] SQLSTATE[HY000] [2002] No such file or directory error for a different reason. I had just finished building a brand new LAMP stack on Ubuntu 12.04 with Apache 2.4.7, PHP v5.5.10 and MySQL 5.6.16. I moved my sites back over and fired them up. But, I couldn’t load my Laravel 4.2.x based site because of the [PDOException] above. So, I checked php -i | grep pdo and noticed this line:

pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock

But, in my /etc/my.cnf the sock file is actually in /var/run/mysqld/mysqld.sock.

So, I opened up my php.ini and set the value for pdo_mysql.default_socket:

pdo_mysql.default_socket=/var/run/mysqld/mysqld.sock

Then, I restarted apache and checked php -i | grep pdo:

pdo_mysql.default_socket => /var/run/mysqld/mysqld.sock => /var/run/mysqld/mysqld.sock

That fixed it for me.

answered Mar 20, 2014 at 3:51

The answer from @stuyam solved the «No such file or directory» issue for me

Short answer: Change «host» in the /app/config/database.php file from «localhost» to «127.0.0.1»

But then I had a «Connection refused» error. If anyone had the same issue, my solution for this was to update the app/config/local/database.php file so the port is 8889:

'mysql' => array(
        'driver'    => 'mysql',
        'host'      => '127.0.0.1',
        'port'      => '8889',
        'database'  => 'databaseName',
        'username'  => 'root',
        'password'  => 'root',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
    ),

In my case i had no problem at all, just forgot to start the mysql service…

sudo service mysqld start

If you are using Laravel Homestead, make sure you’re calling the commands on the server.

homestead ssh

Then simply cd to the right directory and fire your command there.

answered Mar 3, 2015 at 15:04

answered Sep 19, 2018 at 6:01

Thomas DecauxThomas Decaux

21.5k2 gold badges113 silver badges123 bronze badges

Add mysql.sock path in database.php file like below example

'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',

Eample

'mysql' => [
        'driver' => 'mysql',
        'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '8889'),

answered May 14, 2016 at 5:50

Mamp user enable option Allow network access to MYSQL

answered Feb 23, 2016 at 9:38

answered Feb 28, 2017 at 20:16

Building on the answer from @dcarrith …

Instead of editing the config files, I created an alias in the location that PHP is looking that connects to the real mysql.sock. (source)

Just run these two commands (no restart needed):

mkdir /var/mysql
ln -s /tmp/mysql.sock /var/mysql/mysql.sock

anoraqanoraq

5157 silver badges9 bronze badges

answered Aug 27, 2021 at 11:56

I had this problems when I was running my application using docker containers.

The solution was put the name of the MySQL service container I was using in docker_compose.yml on DB_HOST. In my case, it was db :

DB_HOST=db

Hope it helps.

answered Jan 7, 2019 at 3:00

answered Mar 4, 2018 at 13:44

answered Jul 1, 2015 at 8:26

I had the same problem using Docker and MySQL service name db in docker_compose.yml file:

I added the following in the .env file:

DB_HOST=db

you should also assure that your host is discoverable from the php app.

It was because PHP didn’t figure out which host to use to connect.

answered Mar 8, 2020 at 21:07

HasinurHasinur

1961 silver badge6 bronze badges

malhalmalhal

25.5k7 gold badges113 silver badges131 bronze badges

If you are using Laravel Homestead,
here is settings

(include Vagrant-Virtual Machine)

.bash-profile

alias vm="ssh vagrant@127.0.0.1 -p 2222"

database.php

    'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', '127.0.0.1'),
        'database'  => env('DB_DATABASE', 'homestead'),
        'username'  => env('DB_USERNAME', 'homestead'),
        'password'  => env('DB_PASSWORD', 'secret'),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

Terminal

vm

vagrant@homestead:~/Code/projectFolder  php artisan migrate:install

answered Jun 21, 2015 at 22:22

answered Dec 13, 2015 at 1:20

james2doylejames2doyle

1,39919 silver badges21 bronze badges

BradBrad

12k44 gold badges118 silver badges186 bronze badges

In my case I had to remove the bootstrap/cache folder and try it again.

My cenario was after a server migration.

UPDATED AND WORKING

1. Remove folder «cache» from bootstrap (booststrap/cache)
2. Copy folder «cache» from original folder and paste it in bootstrap
3. Run these commands:
   3.1) php artisan config:cache
   3.2) php artisan migrate
   3.3) php artisan db:see
   3.4) php artisan serve

That’s all.

cmaccmac

3,0655 gold badges36 silver badges49 bronze badges