SQLSTATE [HY000]：[Microsoft] [SQL Server的ODBC驱动程序11] TDS协议错误

Question

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();

Answer 1

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()