change database connection just for 1 user

Question

I need to use another db connection just for 1 user.

First of all I created another connection in the config/database.php file:

'mysqltest' => [
    'driver' => 'mysql',
    //...
],

It works. I tried it with something like this Model::on('mysqltest')->all().
Now I would like to change connection everywhere in the project, so I thought to change it after user login.
I'm trying this without success:

protected function authenticated(Request $request, $user)
{
    //
    if ($user->user_id == 1) {
        //DB::purge('mysqltest');
        //DB::reconnect('mysqltest');
        DB::setDefaultConnection('mysqltest');
    }
}

Take a look at this thread: https://stackoverflow.com/questions/36085131/laravel-connect-to-databases-dynamically — dengsauve, Oct 07 '20 at 22:44
Might be worth trying a `DB::reconnect` after setting the default connection — apokryfos, Oct 07 '20 at 23:08

score 1 · Answer 1 · answered Oct 08 '20 at 00:19

Create middleware for example

php artisan make:middleware SelectDB

    <?php

    namespace App\Http\Middleware;

    use Closure;
    use Illuminate\Http\Request;
    use Illuminate\Support\Facades\DB;

    class SelectDB
    {

        public function handle(Request $request, Closure $next)
        {
            if (auth()->id() == 1) {
                DB::setDefaultConnection('mysqltest');
            }

            return $next($request);
        }
    }

Add middleware in App\Http\Kernel

    protected $middlewareGroups = [
            'web' => [
                \App\Http\Middleware\SelectDB::class,
                \App\Http\Middleware\EncryptCookies::class,
             ...

Need to define new sql connection in .env file and config/database.php Work for me in Laravel 8. — Yauhen Kib, Oct 08 '20 at 07:17

change database connection just for 1 user

1 Answers1