Support the ongoing development of Laravel.io →
Security Database Installation

Hello Everyone, Every morning I try to open my client system I get the below error.

To solve it, I kill mysqld service in ubuntu and restart it, then everything goes fine. Any suggestion for this problem ?


PDOException in Connector.php line 55: SQLSTATE[HY000] [2002]

in Connector.php line 55 at PDO->__construct('mysql:host=localhost;port=3306;dbname=dbname', 'username', 'password', array('0', '2', '0', false, false)) in Connector.php line 55 at Connector->createConnection('mysql:host=localhost;port=3306;dbname=dbname', array('driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => 'dbname', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, 'name' => 'mysql'), array('0', '2', '0', false, false)) in MySqlConnector.php line 24 at MySqlConnector->connect(array('driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => 'dbname', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, 'name' => 'mysql')) in ConnectionFactory.php line 61 at ConnectionFactory->Illuminate\Database\Connectors{closure}() at call_user_func(object(Closure)) in Connection.php line 924 at Connection->getPdo() in Connection.php line 792 at Connection->reconnectIfMissingConnection() in Connection.php line 677 at Connection->run('select * from serviceusers where id = ? and remember_token = ? limit 1', array('505', 'cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB'), object(Closure)) in Connection.php line 349 at Connection->select('select * from serviceusers where id = ? and remember_token = ? limit 1', array('505', 'cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB'), true) in Builder.php line 1610 at Builder->runSelect() in Builder.php line 1596 at Builder->get(array('*')) in Builder.php line 1577 at Builder->first() in DatabaseUserProvider.php line 74 at DatabaseUserProvider->retrieveByToken('505', 'cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB') in SessionGuard.php line 186 at SessionGuard->getUserByRecaller('505|cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB') in SessionGuard.php line 141 at SessionGuard->user() in GuardHelpers.php line 49 at SessionGuard->check() in GuardHelpers.php line 59 at SessionGuard->guest() in Authenticate.php line 20 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartSession.php line 64 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) in EncryptCookies.php line 59 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102 at Pipeline->then(object(Closure)) in Router.php line 726 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699 at Router->dispatchToRoute(object(Request)) in Router.php line 675 at Router->dispatch(object(Request)) in Kernel.php line 246 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 at Pipeline->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102 at Pipeline->then(object(Closure)) in Kernel.php line 132 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99 at Kernel->handle(object(Request)) in index.php line 53

Last updated 3 years ago.
0

This error : SQLSTATE[HY000] [2002], generally refers to a wrong connection attempt or a missing file... Hard to tell here if it's your MySQL that just crash everyday or if it's your Laravel app that make it crash... You should check the database status maybe, repair tables, check your hard drive either I would suggest.

0

Sign in to participate in this thread!

Eventy

Your banner here too?

mhassanist mhassanist Joined 29 Apr 2017

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.