title: Laravel: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
body: <p>after installing a new laravel app 5.7 and trying to migrate I get this error:</p>
  
  <blockquote>
    <p>Illuminate\Database\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = xxx_db and table_name = migrations)</p>
    
    <p>at
    C:\xampp\htdocs\xxxxx\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664
    660| // If an exception occurs when attempting to run a query, we'll
    format the error 661| // message to include the bindings with SQL,
    which will make this exception a 662| // lot more helpful to the
    developer instead of just the database's errors. 663| catch (Exception
    $e) {</p>
    
    <p>664| throw new QueryException( 665| $query,
    $this->prepareBindings($bindings), $e 666| ); 667| } 668|</p>
    
    <p>Exception trace:</p>
    
    <p>1 PDOException::("PDO::__construct(): The server requested
    authentication method unknown to the client [caching_sha2_password]")
    C:\xampp\htdocs\xxxxx\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70</p>
    
    <p>2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=xxx_db ",
    "root", "**********", [])
    C:\xampp\htdocs\xxxxx\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70</p>
    
    <p>Please use the argument -v to see more details.</p>
  </blockquote>