运行迁移时“没有这样的文件或目录”或“不知道这样的主机”

Question

我从名为 laravel 的 Laravel 5.4 数据库中删除了 migrations 表。当我运行 php artisan migrate:install 时，我收到此错误：

 [Illuminate\Database\QueryException]
SQLSTATE[HY000] [2002] No such file or directory
(SQL: select * from information_schema.tables where table_schema = laravel
    and table_name = migrations)

我删除并重新创建了数据库。我也跑了 composer update 。没运气。我可以在 phpMyAdmin 中运行命令并手动创建表。

这个问题有时也会出现类似的 2002 错误：

 [Illuminate\Database\QueryException]
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No such host is known.
(SQL: select * from information_schema.tables where table_schema = laravel
    and table_name = migrations and table_type = 'BASE TABLE')

 [Illuminate\Database\QueryException]
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
(SQL: select * from information_schema.tables where table_schema = laravel
    and table_name = migrations and table_type = 'BASE TABLE')

原文由 Jay Bienvenu 发布，翻译遵循 CC BY-SA 4.0 许可协议

Answer 1

If you are using localhost as your DATABASE_HOST in the .env file, change it to 127.0.0.1 , then run php artisan config:clear 现在再次尝试 php artisan migrate:install 。

原文由 Camilo 发布，翻译遵循 CC BY-SA 4.0 许可协议

Answer 2

对于 mac 用户，将其添加到您的 .env 文件中

DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock

原文由 MUHINDO 发布，翻译遵循 CC BY-SA 4.0 许可协议