I have a laravel app that works fine with DB_HOST=localhost but does not work with DB_HOST=127.0.0.1. Does anyone know why this is happening ?
PDOException in PDOConnection.php line 43:
SQLSTATE[HY000] [2002] Permission denied
in PDOConnection.php line 43
at PDO->__construct('mysql:host=127.0.0.1;port=3306;dbname=ncorp', 'username', 'password', array('0', '2', '0', false, false)) in PDOConnection.php line 43
at PDOConnection->__construct('mysql:host=127.0.0.1;port=3306;dbname=ncorp', 'username', 'password', array('0', '2', '0', false, false)) in Connector.php line 116
at Connector->createPdoConnection('mysql:host=127.0.0.1;port=3306;dbname=ncorp', 'username', 'password', array('0', '2', '0', false, false)) in Connector.php line 56
at Connector->createConnection('mysql:host=127.0.0.1;port=3306;dbname=ncorp', array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'ncorp', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_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' => 'ncorp', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, 'name' => 'mysql')) in ConnectionFactory.php line 126
at ConnectionFactory->Illuminate\Database\Connectors\{closure}()
at call_user_func(object(Closure)) in Connection.php line 965
at Connection->getPdo() in Connection.php line 986
at Connection->getReadPdo() in Connection.php line 423
at Connection->getPdoForSelect(true) in Connection.php line 333
at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select * from `users` where `email` = ? limit 1', array('test@test.com')) in Connection.php line 763
at Connection->runQueryCallback('select * from `users` where `email` = ? limit 1', array('test@test.com'), object(Closure)) in Connection.php line 726
at Connection->run('select * from `users` where `email` = ? limit 1', array('test@test.com'), object(Closure)) in Connection.php line 351
at Connection->select('select * from `users` where `email` = ? limit 1', array('test@test.com'), true) in Builder.php line 1648
at Builder->runSelect() in Builder.php line 1634
at Builder->get(array('*')) in Builder.php line 638
at Builder->getModels(array('*')) in Builder.php line 327
at Builder->get(array('*')) in Builder.php line 297
at Builder->first() in EloquentUserProvider.php line 104
at EloquentUserProvider->retrieveByCredentials(array('email' => 'test@test.com', 'password' => 'secret')) in SessionGuard.php line 353
at SessionGuard->attempt(array('email' => 'test@test.com', 'password' => 'secret'), false, false) in SessionGuard.php line 256
at SessionGuard->validate(array('email' => 'test@test.com', 'password' => 'secret')) in SessionGuard.php line 239
at SessionGuard->once(array('email' => 'test@test.com', 'password' => 'secret')) in AuthManager.php line 294
at AuthManager->__call('once', array(array('email' => 'test@test.com', 'password' => 'secret'))) in IlluminateAuthAdapter.php line 39
at AuthManager->once(array('email' => 'test@test.com', 'password' => 'secret')) in IlluminateAuthAdapter.php line 39
at IlluminateAuthAdapter->byCredentials(array('email' => 'test@test.com', 'password' => 'secret')) in JWTAuth.php line 108
at JWTAuth->attempt(array('email' => 'test@test.com', 'password' => 'secret')) in Facade.php line 237
at Facade::__callStatic('attempt', array(array('email' => 'test@test.com', 'password' => 'secret'))) in AuthController.php line 22
at JWTAuth::attempt(array('email' => 'test@test.com', 'password' => 'secret')) in AuthController.php line 22
at AuthController->authenticate(object(Request))
at call_user_func_array(array(object(AuthController), 'authenticate'), array(object(Request))) in Controller.php line 55
at Controller->callAction('authenticate', array(object(Request))) in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(AuthController), 'authenticate') in Route.php line 190
at Route->runController() in Route.php line 144
at Route->run(object(Request)) in Router.php line 653
at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ThrottleRequests.php line 49
at ThrottleRequests->handle(object(Request), object(Closure), '60', '1') in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
at Pipeline->then(object(Closure)) in Router.php line 655
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
at Router->dispatchToRoute(object(Request)) in Router.php line 607
at Router->dispatch(object(Request)) in Kernel.php line 268
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
at Pipeline->then(object(Closure)) in Kernel.php line 150
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
at Kernel->handle(object(Request)) in index.php line 54
Can you check your mySQL server to make sure your username has access to the server on both 127.0.0.1 and localhost? They can be different users depending on your setup.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community