QueryException در لاراول

[yashilmarket]

QueryExceptionSQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

چجوری حلش کنم دوستان؟

[plague]

مشکل از Mysql هستش
اگه wamp استفاده میکنی چک کن mysql فعال باشه و پورتش آزاد باشه

[yashilmarket]

از xampp استفاده میکنم
mysql منم فعال هستش
تست هم کردن ...
دلیل دیگه ای نداره
که بتونم حلش کنم توی لاراول
.
.
.
اینم فایل .env

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=myDB
DB_USERNAME=root
DB_PASSWORD=

DB_HOST رو هم 127.0.0.1 گداشتم هم localhost
ولی بازم وصل نشد

[yashilmarket]

این قایل database.php

<?php
return [
/* |-------------------------------------------------------------------------- | Default Database Connection Name |-------------------------------------------------------------------------- | | Here you may specify which of the database connections below you wish | to use as your default connection for all database work. Of course | you may use many connections at once using the Database library. | */
'default' => env('DB_CONNECTION', 'mysql'),
/* |-------------------------------------------------------------------------- | Database Connections |-------------------------------------------------------------------------- | | Here are each of the database connections setup for your application. | Of course, examples of configuring each database platform that is | supported by Laravel is shown below to make development simple. | | | All database work in Laravel is done through the PHP PDO facilities | so make sure you have the driver for your particular database of | choice installed on your machine before you begin development. | */
'connections' => [
'sqlite' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', database_path('database.sqlite')), 'prefix' => '', ],
'driver' => 'mysql', 'host' => env('DB_HOST', 'localhost'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'testDB'), 'username' => env('DB_USERNAME', 'root'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, ],
'pgsql' => [ 'driver' => 'pgsql', 'host' => env('DB_HOST', 'localhost'), 'port' => env('DB_PORT', '5432'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8', 'prefix' => '', 'schema' => 'public', 'sslmode' => 'prefer', ],
'sqlsrv' => [ 'driver' => 'sqlsrv', 'host' => env('DB_HOST', 'localhost'), 'port' => env('DB_PORT', '1433'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8', 'prefix' => '', ],
],
/* |-------------------------------------------------------------------------- | Migration Repository Table |-------------------------------------------------------------------------- | | This table keeps track of all the migrations that have already run for | your application. Using this information, we can determine which of | the migrations on disk haven't actually been run in the database. | */
'migrations' => 'migrations',
/* |-------------------------------------------------------------------------- | Redis Databases |-------------------------------------------------------------------------- | | Redis is an open source, fast, and advanced key-value store that also | provides a richer set of commands than a typical key-value systems | such as APC or Memcached. Laravel makes it easy to dig right in. | */
'redis' => [
'client' => 'predis',
'default' => [ 'host' => env('REDIS_HOST', 'localhost'), 'password' => env('REDIS_PASSWORD', null), 'port' => env('REDIS_PORT', 6379), 'database' => 0, ],
],
];



اینم فایل .env


DB_CONNECTION=mysqlDB_HOST=localhostDB_PORT=3306DB _DATABASE=testDBDB_USERNAME=rootDB_PASSWORD=123456 78

[plague]

از کجا میدونی mysql فعاله ؟ من با xamp کار نمیکنم نمیدونم از کجا میشه چک کرد که Mysql اجرا شده یا نه
ولی یه راه ساده تر هست , سعی کن phpmyadmin رو بیاری بالا و بری تو دیتابیست از اونجا اگه بالا اومد یعنی mysql داره اجرا میشه

یه احتمال دیگه ای هم وجود داره که پورت دیتبیاست 3306 نباشه که البته اگه دستکاری نکرده باشی احتمالش کمه

[yashilmarket]

mysql ام start هستش
phpmyadmin هم بالا میاد
پورت هم روی 3306 هستش
دیگه نمیدونم چی کار کنم؟!:اشتباه: