PHP 7.2.2 + mysql 8.0 PDO gives: authentication method unknown to the client [caching_sha2_password] : <p>I'm using php 7.2.2 and mysql 8.0.</p>

<p>When I try to connect with the right credential I get this error:</p>

<pre><code>PDOException::("PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]")
</code></pre>

<p>Need help to troubleshoot the problem.</p>
