How to change the Auth database of Laravel 4.2?

Question

My project has two databases: one for the user account and another for the project domain. My need is to define the database that the Auth uses for authentication, because in the default configuration the domain database is defined.

return array(

'default' => 'mysql_domain', 

I wanted to change this definition above to the Auth and so it does not use the domain database.

'connections' => array(

    'mysql_account' => array(
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'user_agro_admin',
        'username'  => 'root',
        'password'  => '',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
    ),

    'mysql_domain' => array(
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'indicator_agro_admin',
        'username'  => 'root',
        'password'  => '',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
    )

),

In the configuration of auth it is possible to just define the driver, model and table. My need could be solved only if there was the method Auth::setDefaultConnection('mysql_account') or something similar. How to do this?

P.S.: I don’t want to change the default setting with the method Config::set('database.fo', 'bar'), and yes, change the database that the Auth uses!

P.S.2.: I use Query Builder.

Answer 1

Wouldn’t it be possible to just change the connection in the User model? According to the documentation of the Eloquent, it is possible to do this:

protected $connection = 'connection-name';