mysql导出的csv是乱码

SELECT * INTO OUTFILE '/path/to/your/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
CHARACTER SET utf8mb4;

mysqldump --user=root --password=your_password --default-character-set=utf8mb4 your_database > /path/to/your/file.csv

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

import csv
import MySQLdb

# 连接数据库
db = MySQLdb.connect(host="localhost", user="root", passwd="your_password", db="your_database", charset='utf8mb4')
cursor = db.cursor()

# 执行查询
cursor.execute("SELECT * FROM your_table")

# 导出CSV
with open('/path/to/your/file.csv', 'w', newline='', encoding='utf-8-sig') as f:
    writer = csv.writer(f)
    writer.writerow([i[0] for i in cursor.description])  # 写入列名
    writer.writerows(cursor.fetchall())

# 关闭连接
cursor.close()
db.close()