title: caching sha2 password is not supported mysql
body: <p>i'm trying to get my python program to insert data into MySQL and i followed a guide however i keep getting the error below.</p>
  
  <p><strong>"Authentication plugin '{0}' is not supported".format(plugin_name))
  mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported"</strong></p>
  
  <p>have i missed a setting in mysql server or does python not support this yet?</p>
  
  <p>I think i can just change the password type but mysql doesn't want to let me for some reason all users with caching_sha2_password can't be changed and when i create a new user and select SHA256 Password I get the error creating account @% the password hash doesn't have the expected format. check if the correct password algorithm is being used with the PASSWORD() function.</p>
  
  <pre><code>#!/user
  # -*- coding: utf-8 -*-
  
  from __future__ import print_function
  import urllib.request
  import numpy as np
  import mysql.connector as mysql
  
  from datetime import date, datetime, timedelta
  
  
  
  cnx = mysql.connect(user='root', password='password', database='powergrid')
  
  cursor = cnx.cursor()
  
  tomorrow = datetime.now().date() + timedelta(days=1)
  
  idfueltype= cursor.lastrowid
  
  add_fueltype = ("INSERT INTO fueltype"
                  "(idfueltype, fueltypecol, demand)"
                 "VALUES(%s, %s, %s)")
  
  fueltype_data = (idfueltype, 'coal', 10000)
  
  cursor.execute(add_fueltype, fueltype_data)
  
  cnx.commit()
  
  cursor.close()
  cnx.close()
  </code></pre>