PDOException SQLSTATE HY000 2002 No such file or directory

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

User · Answer

Laravel 4  Change  quot host quot  in the app config database php file from  quot localhost quot  to  quot 127 0 0 1 quot  Laravel 5   Change  quot DB HOST quot  in the  env file from  quot localhost quot  to  quot 127 0 0 1 quot   I had the exact same problem  None of the above solutions worked for me  I solved the problem by changing the  quot host quot  in the  app config database php file from  quot localhost quot  to  quot 127 0 0 1 quot   Not sure why  quot localhost quot  doesn t work by default but I found this answer in a similar question solved in a symfony2 post  https   stackoverflow com a 9251924 1231563 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 1231563 The issue that arose here is that  quot localhost quot  uses a UNIX socket and can not find the database in the standard directory  However  quot 127 0 0 1 quot  uses TCP  Transmission Control Protocol   which essentially means it runs through the  quot local internet quot  on your computer being much more reliable than the UNIX socket in this case

User · Answer

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    Open a terminal and connect to the mysql with   mysql -u root -p  It will ask you for the related password  Then once you get the mysql promt type the next command   mysql gt  show variables like   sock    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    ----------------------------------------- -----------------   Keep the value of the last row    tmp mysql sock  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    gt    tmp mysql sock   You must have something like this    mysql    gt  array           driver       gt   mysql            host         gt   localhost            database     gt   SchoolBoard            username     gt   root            password     gt   venturaa            charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt               unix socket    gt    tmp mysql sock             Now just save changes  and reload the page and it must work

User · Answer

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

User · Answer

For anyone trying to create a fresh db connection not on laravel but bumped here seeking for answers to run PDO from the Terminal  This would be of help to you  And you can refactor it to work best for you    lt  php  class db      private  DBHOST    localhost      you don t need 127 0 0 1    private  DRIVER    mysql      private  PORT      8888      database port  8888 is mine    private  DB        example-db      private  PASS      example-pass      private  USER      root      private  SOCKS           can fill this or leave blank          - connect  dummy connection     private function con               if   this- gt SOCKS                               run shell command to get              socks   shell exec  netstat -ln   grep mysql                socks   trim substr  socks  strpos  socks                       this- gt SOCKS   strlen  socks   gt  0     unix socket    socks                       else                     this- gt SOCKS     unix socket    this- gt SOCKS                    dsn    this- gt DRIVER   host    this- gt DBHOST   dbname    this- gt DB             add socks         dsn     this- gt SOCKS             add port         dsn     strlen  this- gt PORT   gt  0      port    this- gt PORT                  extablish connection         con   new PDO  dsn   user   pass              return PDO instance         return  con             - ends here        now you can call  this- gt con   within class to use connection        would run fine on any terminal       hope it helps

User · Answer

In my case I had to remove the bootstrap cache folder and try it again   My cenario was after a server migration

User · Answer

I had similar problems accessing my Drupal website  I fixed it by opening the command line  and restarting my MySQL server or service   service mysqld restart   This should work  If it doesn t  restart your local webserver   service httpd restart   That should be enough  Hope it works for other environments  too  Note that these commands generally require superuser privileges

User · Answer

I got the same problem in ubuntu 18 04 with nginx  By following the below steps my issue has been fixd  First open terminal and enter into mysql CLI  To check mysql socket location I write the following command  mysql gt  show variables like   sock    I got something like the below    ----------------------------------------- -----------------------------    Variable name                             Value                          ----------------------------------------- -----------------------------    mysqlx socket                              var run mysqld mysqlx sock     performance schema max socket classes     10                              performance schema max socket instances   -1                              socket                                     var run mysqld mysqld sock    ----------------------------------------- -----------------------------  4 rows in set  0 00 sec   In laravel project folder  look for the database php file in the config folder  In the mysql section I modified unix socket according to the above table   mysql    gt  array           driver       gt   mysql            host         gt   127 0 0 1            database     gt   database name            username     gt   username            password     gt   password            charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt               unix socket    gt    var run mysqld mysqld sock           Now just save changes  and reload the page and it worked

User · Answer

Mamp user enable option Allow network access to MYSQL

User · Answer

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

User · Answer

When using a VirtualMachine make sure you ssh into that machine and navigate to your App folder and call the php artisan migrate command from there

User · Answer

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

User · Answer

Step 1 Find the path to your unix socket  to do that just run  netstat -ln   grep mysql You should get something like this unix  2        ACC       STREAM     LISTENING     17397     var run mysqld mysqld sock  Step 2 Take that and add it in your unix socket param  mysql    gt  array               driver       gt   mysql                host         gt   67 25 71 187                database     gt   dbname                username     gt   username                password     gt                      charset      gt   utf8                collation    gt   utf8 unicode ci                prefix       gt                   unix socket       gt    var run mysqld mysqld sock   lt -----                            Hope it helps

User · Answer

It worked after I change from DB HOST localhost to DB HOST 127 0 0 1 at  env file

User · Answer

In my case  I was running php artisan migrate on my mac terminal  when I needed to ssh into vagrant and run it from there  Hope that helps someone the headache

User · Answer

As of Laravel 5 the database username and password goes in the  env file that exists in the project directory  e g   DB HOST 127 0 0 1 DB DATABASE db1 DB USERNAME user1 DB PASSWORD pass1   As you can see these environment variables are overriding the  forge  strings here so changing them has no effect        mysql    gt             driver       gt   mysql            host         gt  env  DB HOST    localhost             database     gt  env  DB DATABASE    forge             username     gt  env  DB USERNAME    forge             password     gt  env  DB PASSWORD                 charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt               strict       gt  false           More information is here https   mattstauffer co blog laravel-5 0-environment-detection-and-environment-variables

User · Answer

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

User · Answer

Attempt to connect to localhost   SQLSTATE HY000   2002  No such file or directory   Attempt to connect to 127 0 0 1   SQLSTATE HY000   2002  Connection refused   OK  just comment   remove the following setting from my cnf  on OS X 10 5   opt local etc mysqlxx my cnf  to obtain    mysqld    skip-networking   Of course  stop and start MySQL Server

User · Answer

If anyone are still looking for the answer  just check your  env file  For some reason laravel create a  env example file  so all this answers didn t work for me  I fixed my issue renamming  env example to  env

User · Answer

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

User · Answer

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    gt  array           driver       gt   mysql            host         gt   127 0 0 1            port         gt   8889            database     gt   databaseName            username     gt   root            password     gt   root            charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt

User · Answer

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   gt   tmp mysql sock   gt   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   gt   var run mysqld mysqld sock   gt   var run mysqld mysqld sock   That fixed it for me

User · Answer

Add mysql sock path in database php file like below example   unix socket    gt    Applications MAMP tmp mysql mysql sock     Eample    mysql    gt             driver    gt   mysql            unix socket    gt    Applications MAMP tmp mysql mysql sock            host    gt  env  DB HOST    localhost             port    gt  env  DB PORT    8889

User · Answer

My answer is specific to Laravel    I had this message after creating a new connection in the database php configuration file to a local Docker MySQL service and setting it as the default connection  I forgot that I was setting a different connection by overwriting it in the Model   class Model extends  Illuminate Database Eloquent Model       protected  connection       public function   construct array  attributes                     parent    construct  attributes            this- gt connection    some other connection               So even if my default connection in the database php file was pointing to the right credentials  the model was still using the remote database connection configuration which I had removed from the local environment file

User · Answer

This happened to me because MySQL wasn t running  MySQL was failing to start because I had a missing  usr local etc my cnf d  directory   This was being required by my  usr local etc my cnf config file as a glob include  include  usr local etc my cnf d   cnf    Running mkdir  usr local etc my cnf d  and then starting MySQL  fixed the issue

User · Answer

I ran into this problem when running PHPUnit in Elixir Gulp  and Homestead as my Vagrant enviroment   In my case I edited the  env file from DB HOST localhost to DB HOST 192 168 10 10 where 192 168 10 10 is the IP of my Vagrant Homestead host

User · Answer

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    gt             driver       gt   mysql            host         gt  env  DB HOST    127 0 0 1             database     gt  env  DB DATABASE    homestead             username     gt  env  DB USERNAME    homestead             password     gt  env  DB PASSWORD    secret             charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt               strict       gt  false           Terminal  vm  vagrant homestead   Code projectFolder  php artisan migrate install

User · Answer

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

User · Answer

Check your port carefully   In my case it was 8889 and i am using 8888   change  DB HOST  from  localhost  to  127 0 0 1  and vice versa

User · Answer

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

User · Answer

I m running on MAMP Pro and had this similar problem when trying to migrate  create db tables   Tried a few of these mentioned suggestions as well but didn t do it for me    So  simply  after an hour googling   I added two things to the  config database php    port    gt   1234    unix socket    gt    path to my socket mysqld sock    Works fine now

User · Answer

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

User · Answer

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

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

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to pdo