title: Authentication plugin 'caching_sha2_password' is not supported
body: <p>I am trying to connect to a MySQL server with python connector. I created a new user <code>lcherukuri</code> with the authentication plugin <code>mysql_native_password</code>.</p>
  
  <p>But I got the error</p>
  
  <blockquote>
    <p>mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported</p>
  </blockquote>
  
  <p>Can someone help me? </p>
  
  <pre><code>import mysql.connector
  
  cnx = mysql.connector.connect(user='lcherukuri', password='password',
                                host='127.0.0.1',
                                database='test')
  cnx.close()
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/bmCIc.png" rel="noreferrer"><img src="https://i.stack.imgur.com/bmCIc.png" alt="enter image description here"></a></p>