mercredi 11 octobre 2017

Laravel Multiple Database Connections not working

I am using more than 1 database connection in my Laravel development but it is not getting the right information;

/config/database.php

'connections' => [
    'database' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'port'      => env('DB_PORT', '3306'),
        'database'  => env('DB_DATABASE', 'forge'),
        'username'  => env('DB_USERNAME', 'forge'),
        'password'  => env('DB_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => true,
        'engine'    => null,
    ],

    'database2' => [
        'driver'    => 'mysql',
        'host'      => env('DB2_HOST', 'localhost'),
        'port'      => env('DB2_PORT', '3306'),
        'database'  => env('DB2_DATABASE', 'forge'),
        'username'  => env('DB2_USERNAME', 'forge'),
        'password'  => env('DB2_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => true,
        'engine'    => null,
    ]
],

in my Controller

$result = DB::connection('database2')->table('mytable')->select('*')->get();

I am getting the error response;

SQLSTATE[HY000] [1045] Access denied for user 'user'@'000.000.000.000' (using password: YES)

However the ip address it shows is for 'database' even though I am trying to connect to 'database2'



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire