mysql无法保存汉字

import mysql.connector

config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database_name',
    'charset': 'utf8mb4'
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()

    # 创建表
    create_table_query = """
    CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    """
    cursor.execute(create_table_query)

    # 插入数据
    insert_query = "INSERT INTO users (name) VALUES (%s)"
    data = ("张三",)
    cursor.execute(insert_query, data)
    cnx.commit()

except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if cnx.is_connected():
        cursor.close()
        cnx.close()
        print("MySQL connection is closed")