php artisan db command does not work when separate read and write hosts are configures in db config

[aleexdhillon]

• Laravel Version: 8.77.1
• PHP Version: 7.4.27
• Database Driver & Version:
  mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Description:

I have configured separate read and write connections in database config file, like below

And when running the php artisan db it cannot find the host and throw exception.

Steps To Reproduce:

1. Setup the separate read write connections for mysql in database config
   'read' => [ 'host' => [ env('DB_HOST_SLAVE', '127.0.0.1') ], ], 'write' => [ 'host' => [ env('DB_HOST_MASTER', '127.0.0.1') ], ],
2. Run php artisan db or php artisan db mysql

[jelib3an]

You can use php artisan db --read or php artisan db --write to specify which host to use. But it appears there is a bug with that too. It doesn't work if host is an array...

This works though

'read' => [
    'host' => env('DB_HOST_SLAVE', '127.0.0.1'),
],
'write' => [
    'host' => env('DB_HOST_MASTER', '127.0.0.1'),
],

But this does NOT...

'read' => [
    'host' => [
        env('DB_HOST_SLAVE', '127.0.0.1'),
    ],
],
'write' => [
    'host' => [
        env('DB_HOST_MASTER', '127.0.0.1'),
    ],
],