title: MySQL error in Python - cannot connect to MySQL server
body: <p>I have a question:</p>
  <p>My input:</p>
  <pre><code>import mysql.connector
  import mysql.connector
  
  mydb = mysql.connector.connect(
      host = 'localhost',
      user = 'root',
      passwd = 'ananthjeahinowiamshowingmypasswordwitchisnotmypassword'
  )
  print(mydb)
  </code></pre>
  <p>And this is the output:</p>
  <blockquote>
  <p>mysql.connector.errors.NotSupportedError: Authentication plugin <br />
  'caching_sha2_password' is not supported</p>
  </blockquote>