title: Getting 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' and alter user doesn't fix this
body: <p>I'm using knex and have mysql 8 installed. Trying to make a simple connection but getting
  'Client does not support authentication protocol requested by server; consider upgrading MySQL client'</p>
  <pre><code>const knex = require('knex');
  
  const db = knex({
    client: 'mysql',
    connection: {
      host: '127.0.0.1',
      user: 'root',
      password: '12345678',
      database: 'myDatabase'
    },
  });
  
  </code></pre>
  <p>I changed the user to use mysql_native_password by running the query</p>
  <pre><code> alter user 'root'@'localhost' identified with mysql_native_password by '12345678';
  </code></pre>
  <p>but still getting the same error when trying to connect.</p>
  <p>Everything I found online was telling me that this query will fix the problem, I'm wondering if I might be missing something or if there might be another reason I'm getting this error.</p>
  <p>Any help or advice would be much appreciated!</p>