使用Python读取sql数据库时出现字符错误

import mysql.connector

cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database', charset='utf8')

cnx.set_charset_collation('utf8')

data = data.decode('utf8').encode('default_encoding')

import pandas as pd
import pymysql

conn = pymysql.connect(host='localhost', user='username', password='password', database='database', charset='utf8')
query = "SELECT * FROM table"
df = pd.read_sql_query(query, conn, charset='utf8')