title: MySQL connector error: "Authentication plugin 'caching_sha2_password' is not supported"
body: <pre><code>import mysql.connector
  
  mydb = mysql.connector.connect(
  
      host=&quot;localhost&quot;,
      user=&quot;root&quot;,
      password=&quot;henry123test&quot;,
      )
  </code></pre>
  <p>This was the error returned</p>
  <blockquote>
  <p>mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported.</p>
  </blockquote>
  <p>Can anyone help me, been googling for some time now.</p>