SQLSTATE[HY000] [2002] Connection refused (SQL: select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = 1) as `job_count` from `categories`)

(2/2) QueryException

SQLSTATE[HY000] [2002] Connection refused (SQL: select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = 1) as `job_count` from `categories`)

in Connection.php line 664
at Connection->runQueryCallback('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1), object(Closure))in Connection.php line 624
at Connection->run('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1), object(Closure))in Connection.php line 333
at Connection->select('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1), true)in Builder.php line 2130
at Builder->runSelect()in Builder.php line 2118
at Builder->Illuminate\Database\Query\{closure}()in Builder.php line 2604
at Builder->onceWithColumns(array('*'), object(Closure))in Builder.php line 2119
at Builder->get(array('*'))in Builder.php line 521
at Builder->getModels(array('*'))in Builder.php line 505
at Builder->get()in FindJobController.php line 42
at FindJobController->__construct()
at ReflectionClass->newInstanceArgs(array())in Container.php line 825
at Container->build('App\\Http\\Controllers\\FindJobController')in Container.php line 667
at Container->resolve('App\\Http\\Controllers\\FindJobController', array())in Container.php line 615
at Container->make('App\\Http\\Controllers\\FindJobController', array())in Application.php line 767
at Application->make('App\\Http\\Controllers\\FindJobController')in Route.php line 233
at Route->getController()in Route.php line 833
at Route->controllerMiddleware()in Route.php line 794
at Route->gatherMiddleware()in Router.php line 693
at Router->gatherRouteMiddleware(object(Route))in Router.php line 673
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 657
at Router->runRoute(object(Request), object(Route))in Router.php line 623
at Router->dispatchToRoute(object(Request))in Router.php line 612
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 21
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 21
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 62
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 104
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 53

(1/2) PDOException

SQLSTATE[HY000] [2002] Connection refused

in Connector.php line 70
at PDO->__construct('mysql:host=127.0.0.1;port=3306;dbname=paysjob_db', 'adminPaysjob', 'GFdEu2-fg0gE!UbX', array(0, 2, 0, false, false))in Connector.php line 70
at Connector->createPdoConnection('mysql:host=127.0.0.1;port=3306;dbname=paysjob_db', 'adminPaysjob', 'GFdEu2-fg0gE!UbX', array(0, 2, 0, false, false))in Connector.php line 46
at Connector->createConnection('mysql:host=127.0.0.1;port=3306;dbname=paysjob_db', array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'paysjob_db', 'username' => 'adminPaysjob', 'password' => 'GFdEu2-fg0gE!UbX', 'unix_socket' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, 'name' => 'mysql'), array(0, 2, 0, false, false))in MySqlConnector.php line 24
at MySqlConnector->connect(array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'paysjob_db', 'username' => 'adminPaysjob', 'password' => 'GFdEu2-fg0gE!UbX', 'unix_socket' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, 'name' => 'mysql'))in ConnectionFactory.php line 182
at ConnectionFactory->Illuminate\Database\Connectors\{closure}()
at call_user_func(object(Closure))in Connection.php line 919
at Connection->getPdo()in Connection.php line 944
at Connection->getReadPdo()in Connection.php line 399
at Connection->getPdoForSelect(true)in Connection.php line 325
at Connection->Illuminate\Database\{closure}('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1))in Connection.php line 657
at Connection->runQueryCallback('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1), object(Closure))in Connection.php line 624
at Connection->run('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1), object(Closure))in Connection.php line 333
at Connection->select('select `categories`.*, (select count(*) from `jobs` where `categories`.`id` = `jobs`.`category_id` and `status` = ?) as `job_count` from `categories`', array(1), true)in Builder.php line 2130
at Builder->runSelect()in Builder.php line 2118
at Builder->Illuminate\Database\Query\{closure}()in Builder.php line 2604
at Builder->onceWithColumns(array('*'), object(Closure))in Builder.php line 2119
at Builder->get(array('*'))in Builder.php line 521
at Builder->getModels(array('*'))in Builder.php line 505
at Builder->get()in FindJobController.php line 42
at FindJobController->__construct()
at ReflectionClass->newInstanceArgs(array())in Container.php line 825
at Container->build('App\\Http\\Controllers\\FindJobController')in Container.php line 667
at Container->resolve('App\\Http\\Controllers\\FindJobController', array())in Container.php line 615
at Container->make('App\\Http\\Controllers\\FindJobController', array())in Application.php line 767
at Application->make('App\\Http\\Controllers\\FindJobController')in Route.php line 233
at Route->getController()in Route.php line 833
at Route->controllerMiddleware()in Route.php line 794
at Route->gatherMiddleware()in Router.php line 693
at Router->gatherRouteMiddleware(object(Route))in Router.php line 673
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 657
at Router->runRoute(object(Request), object(Route))in Router.php line 623
at Router->dispatchToRoute(object(Request))in Router.php line 612
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 21
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 21
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 62
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 163
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 104
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 53