php SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename 或 servname 提供,或未知

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/33260172/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-25 23:25:24  来源:igfitidea点击:

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known

phpmysqllaravellaravel-5migration

提问by cyber8200

I keep this while running php artisan migrate

我在跑步时保持这个 php artisan migrate

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename 或 servname 提供,或未知

My Environment

我的环境

  • Laravel Framework version 5.1.20 (LTS)
  • Laravel Installer version 1.2.0
  • PHP 5.6.14 (cli) (built: Oct 2 2015 08:55:56)
  • mysql Ver 14.14 Distrib 5.6.24, for osx10.10 (x86_64)
  • Laravel 框架版本 5.1.20 (LTS)
  • Laravel 安装程序 1.2.0 版
  • PHP 5.6.14 (cli)(构建时间:2015 年 10 月 2 日 08:55:56)
  • mysql Ver 14.14 Distrib 5.6.24,用于 osx10.10 (x86_64)


.env file

.env 文件

APP_ENV=local
APP_URL=http://localhost/
APP_DEBUG=true
APP_KEY=****

DB_HOST=http://localhost/
DB_DATABASE=name-local
DB_USERNAME=root
DB_PASSWORD=
UNIX_SOCKET = /tmp/mysql.sock


That data-base name-localis exist in my local database.

name-local数据库存在于我的本地数据库中。

Any hints / suggestions will be a huge help for me.

任何提示/建议对我来说都是一个巨大的帮助。

回答by cyber8200

Check your DB_HOSTon your .envfile

检查您DB_HOST.env文件

DB_HOST=http://localhost/--> DB_HOST=localhost

DB_HOST=http://localhost/--> DB_HOST=localhost



Result:

结果:

I can migrate peacefully now.

我现在可以和平迁移了。

php artisan migrate
Migration table created successfully.
Migrated: 2014_10_12_000000_create_users_table

回答by Suresh Velusamy

Set DB_HOST=localhostand run the following artisan command

设置DB_HOST=localhost并运行以下工匠命令

php artisan config:clearit will help you, clear cached config

php artisan config:clear它会帮助你,清除缓存的配置