Support the ongoing development of Laravel.io →
posted 8 years ago
Configuration

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
Last updated 3 years ago.
0

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.

0

Sign in to participate in this thread!

Eventy

Your banner here too?

rthapa rthapa Joined 22 Mar 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.