SQLSTATE[HY000] [2002] No such file or directory in yii2

Question

I use ubuntu 16.04.
PHP Version 7.0.4-7ubuntu2.
Apache/2.4.18 (Ubuntu) .
PHP extension: mysqli (in phpmyadmin Written).

I got Upgrade my ubuntu from 15.10 to 16.04 and I have this error:

My project correctly run in my server but I can't run that in my os:

Database Exception – yii\db\Exception
SQLSTATE[HY000] [2002] No such file or directory
↵
Caused by: PDOException
SQLSTATE[HY000] [2002] No such file or directory

in /var/www/html/iicitySite/vendor/yiisoft/yii2/db/Connection.php at line 579

Try this http://stackoverflow.com/questions/20723803/pdoexception-sqlstatehy000-2002-no-such-file-or-directory — Web Artisan, Apr 29 '16 at 06:02
I had this problem and the problem was that the database server (mysql) wasn't running — Slim Fadi, Aug 02 '16 at 06:44
have u used localhost if yes ? then try by Changing "localhost" to "127.0.0.1" as your host — vijay nathji, Aug 06 '16 at 08:47

vijay nathji · Accepted Answer · 2017-04-10T04:31:51.797

66

Changing "localhost" to "127.0.0.1" as your host

return [
    'components' => [
        'db' => [
            'class' => 'yii\db\Connection',    
            'dsn' => 'mysql:host=127.0.0.1;dbname=abc',
            'username' => 'root',
            'password' => '',
            'charset' => 'utf8',
        ],

edited Apr 10 '17 at 04:31

answered Aug 06 '16 at 08:52

vijay nathji

1,608
13
23

1

If you use standard Yii2 `docker-compose.yml` your dns must be `mysql:host=mysql;dbname=abc` – Aleksej_Shherbak May 30 '20 at 20:54

score 8 · Answer 2 · answered Sep 10 '17 at 10:55

For MAMP users solution is

'components' => [
    'db' => [
        'class' => 'yii\db\Connection',
        'dsn' => 'mysql:host=localhost;port=8889;dbname=mydbname;unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock',
        'username' => 'myuser',
        'password' => 'mypassword',
        'charset' => 'utf8',
    ],
],

score 3 · Answer 3 · answered Aug 09 '16 at 12:54

3

Hope this answer will help You:

Change the Host name from localhost to 127.0.0.1

This is inside backend\common\config\main-local.php

Now you run php yii migrate .

Hope, It will successfully create the tables in Database

answered Aug 09 '16 at 12:54

Deepak swain

3,380
1
30
26

score 1 · Answer 4 · edited May 15 '17 at 09:58

1

if you use mamp,don't use "php" command in MAC OS, but use "php" in mamp, such as /Applications/MAMP/bin/php/php5.6.30/bin/php yii migrate.

edited May 15 '17 at 09:58

legoscia

39,593
22
116
167

answered May 15 '17 at 09:41

qiaoer

11
2

score 1 · Answer 5 · edited May 23 '18 at 21:05

1

I had this same problem too. Changing localhost didn't solve my problem. Instead, add your db port like this:

'dsn'=>'mysql:host=localhost:3307;dbname=geep'

edited May 23 '18 at 21:05

rob006

21,383
5
53
74

answered May 23 '18 at 11:42

Olamide226

428
6
12

score 1 · Answer 6 · answered Sep 07 '18 at 01:17

1

I'm running on MAMP environment and works well using 2 solutions above

change localhost to 127.0.0.1
remain as localhost and define mysql port even default port been used (localhost:3306)

answered Sep 07 '18 at 01:17

Hairunizam Mohamed Salleh

11
1

Gireesh · Answer 7 · 2020-03-21T13:58:19.827

For PHP 7.2.24-0ubuntu0.18.04.3,

Get mysql socket path
add socket info to the database config of yii2

To get the socket path login to the mysql and perform following steps

Open Terminal and perform following steps

mysql -u root -p
mysql> show variables like '%sock%';
+-----------------------------------------+------------------------------------------------------+
| Variable_name                           | Value                                                |
+-----------------------------------------+------------------------------------------------------+
| mysqlx_socket                           | /tmp/mysqlx.sock                                     |
| performance_schema_max_socket_classes   | 10                                                   |
| performance_schema_max_socket_instances | -1                                                   |
| socket                                  | /opt/packages/lampstack-7.3.9-0/mysql/tmp/mysql.sock |
+-----------------------------------------+------------------------------------------------------+
4 rows in set (0.00 sec)
exit

Next add following config information

'class' => 'yii\db\Connection',
'dsn' => 'mysql:unix_socket=/opt/packages/lampstack-7.3.9-0/mysql/tmp/mysql.sock;dbname=basketmantra',
'username' => 'root',
'password' => 'root123',
'charset' => 'utf8',

I hope this helps

In Some cases you may use httpd or apache or lampp then also make sure to check php and mysql commands in terminal are same as versions web servers are using.

phpinfo() in web server is helpful to find out the versions web server is using

    <?php
        phpinfo();
    ?>

For commands

    $ type php
    php is hashed (/usr/bin/php)

    $ type mysql
    mysql is /opt/packages/lampstack-7.3.9-0/mysql/bin/mysql

score 0 · Answer 8 · answered Jun 11 '21 at 16:08

Using yii2, my solution is to comment codes in common/main-local.php For some reason, yii2 try to get main-local.php in production instead of main.php in the folder common, but when is commented it works (get DB configs on common/main.php

<?php
// common/main-local.php
return [
 /*  'components' => [
       'db' => [
           'class' => 'yii\db\Connection',
           'dsn' => 'mysql:host=172.17.0.2;dbname=ememariadb',
           'username' => 'dbsenha',
           'password' => 'dbUser',
           'charset' => 'utf8',
       ],
   ],*/
];

score 0 · Answer 9 · answered Mar 04 '23 at 14:33

0

In my case I have my setup running in Docker. I had the same error message and had to run the migrate command inside docker.

docker exec -it <container ID> bash
cd app
php yii migrate

answered Mar 04 '23 at 14:33

HVossi92

11
2

SQLSTATE[HY000] [2002] No such file or directory in yii2

9 Answers9

Linked