I tried to connect to a new bbdd from laravel giving me the error that appears in the title I leave below the configuration file of bbdd (database.php) and as we call it from the controller
'reporting' => [
'driver' => 'mysql',
'host' => env('DB_REPORTING_HOST', 'localhost'),
'port' => env('DB_REPORTING_PORT', '3306'),
'database' => env('DB_REPORTING_DATABASE', 'reporting'),
'username' => env('DB_REPORTING_USERNAME', 'paco'),
'password' => env('DB_REPORTING_PASSWORD', 'qwerty'),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
],
and the call
$DB = DB::connection('reporting');
$DB->table('clients')->get();
fix it
'reporting' => [
'driver' => 'mysql',
'host' => '127.0.0.1',
'port' => '3306',
'database' =>'reporting',
'username' => 'paco',
'password' => 'qwerty',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
],
And in the controller
$dataL = DB::connection('reporting');//->select('select * from leyenda');
$dataL2 = $dataL->table('familias')->get()