解决 authentication plugin 'calling_sha2_password' is not supported

import mysql.connector                 

# mysql1.py
config = {
    'host': '127.0.0.1',
    'user': 'root',
    'password': '******',
    'port': 3306,
    'database': 'peng',
    'auth_plugin':'mysql_native_password'
}
try:
    cnn = mysql.connector.connect(**config)
except mysql.connector.Error as e:
    print('connect fails!{}'.format(e))
cursor = cnn.cursor()
try:
    sql_query = 'select 1 value;'
    cursor.execute(sql_query)
    for value in cursor:
        print (value)
except mysql.connector.Error as e:
    print('query error!{}'.format(e))
finally:
    cursor.close()
    cnn.close()

原因：MySQL 8.0以后，默认的身份认证是caching_sha2_password而不是mysql_native_password
一、root 用户登录
二、修改root用户加密方式

mysql> alter user root@localhost identified with mysql_native_password by '930326'; 
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

三、重新连接测试