Change The Database Connection Dynamically In Laravel
Answer : This way you can set new parameter when it comes to database: \Config::set('database.connections.mysql.database', $schemaName); Remember about PURGE to persist this settings DB::purge('mysql'); Cheers! Well you can use the default database for user login and have a new field for the database name. Then whenever you need to query a different database, you can just change your db connection. Something like this $someModel = new SomeModel; $databaseName = "mysql2"; // Dynamically get this value from db $someModel->setConnection($databaseName); $something = $someModel->find(1); You can read more about it here. http://fideloper.com/laravel-multiple-database-connections you need to get the config first.. then alter the specific field then set it back.. $config = Config::get('database.connections.company'); $config['database'] = "company_tenant_$id"; $config['password'] = "test2123";...