title: PHP 7.3.1, PDO, Mysql8 not compatible out of the box anymore? 11/16/2019
body: <p>Edit: Based on the links sent over, it looks like no one read the question, but for those who see this in the future it seems the answer is:
  NO they are not compatible out of the box anymore and you do need to manually change the mysql auth'</p>
  
  <p>We had a small app that we're using for local purposes and have an incredibly insecure simple PDO injection setup to access our mysql. (Works with MYSQL7)</p>
  
  <pre><code>return [
      'database' =&gt; [
          'username' =&gt; 'root',
          'password' =&gt; '',
          'connection' =&gt; 'mysql:host=127.0.0.1',
          'options' =&gt; [
              PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION
          ]
      ]
  ];
  </code></pre>
  
  <p>We upgraded to mysql8 and it looks like MYSQL8 auth is different.</p>
  
  <blockquote>
    <p>SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client 'name'</p>
  </blockquote>
  
  <p>Upgraded to php7.3.1 and same issue.</p>
  
  <p>Previous answers to similar questions say we need to adjust the MYSQL configuration. These posts are a year old though. And we are not competent to do this and feel comfortable.</p>
  
  <p>Question: In 2019 November, is MYSQL8 &amp; PHP7.3.1 &amp; PDO not compatible out of the box with each other? </p>
  
  <p>Is there a change we can make in our connection PDO code or is editing the MYSQL setup or switching to sqlite, etc our only options?</p>