How to use multiple databases in Laravel?

To use multiple databases in Laravel, follow these steps carefully.

• Ensure these settings in the .env file
• Add these following lines of code in the config/database.php file to clearly define the relationship between the two databases
• Execute the query with particular database.

1. Ensure these settings in the .env file

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=your_db_name
DB_USERNAME=bestinterviewquestion
DB_PASSWORD=admin@123

DB_CONNECTION_SECOND=mysql
DB_HOST_SECOND=localhost
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=your_db_name2
DB_USERNAME_SECOND=bestinterviewquestion
DB_PASSWORD_SECOND=admin@12345

2. Add these following lines of code in the config/database.php file to clearly define the relationship between the two databases

'mysql' => [
    'driver'    => env('DB_CONNECTION'),
    'host'      => env('DB_HOST'),
    'port'      => env('DB_PORT'),
    'database'  => env('DB_DATABASE'),
    'username'  => env('DB_USERNAME'),
    'password'  => env('DB_PASSWORD'),
],

'mysql2' => [
    'driver'    => env('DB_CONNECTION_SECOND'),
    'host'      => env('DB_HOST_SECOND'),
    'port'      => env('DB_PORT_SECOND'),
    'database'  => env('DB_DATABASE_SECOND'),
    'username'  => env('DB_USERNAME_SECOND'),
    'password'  => env('DB_PASSWORD_SECOND'),
],

3. Execute Query

$users = DB::connection('your_db_name2')->select();