Yii2 yii\db\exception Error in Linux
- Error indication: Database exception–yii\db\exception sqlstate[hy000] [2002] No such file or director error
- Reason: PDO cannot be linked to a mysql.sock (or mysqld.sock) file path in PHP configuration file php.ini Database resolution is to manually point to the Mysql.sock path in the php.ini file
- Workaround:
//第一步找到mysql.sock值MariaDB [(none)]> show variables like ‘%sock%‘;+---------------+------------------------+| Variable_name | Value |+---------------+------------------------+| socket | /work/mysql/mysql.sock |+---------------+------------------------+1 row in set (0.00 sec) //找到php.ini文件 find / -iname php.ini //修改php.ini中对应字段值 vim php.ini mysql.default_socket = /tmp/mysql.sock pdo_mysql.default_socket = /tmp/mysql.sock mysqli.default_socket = /tmp/mysql.sock //重启mysql和php-fpm service mysqld restart killall php-fpm service php-fpm start
LINUX-->YII2 report Yii\db\exception wrong