连mysql 中文乱码

-- 设置数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci;

-- 设置表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

-- 设置列字符集
ALTER TABLE your_table_name MODIFY your_column_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql -u your_username -p --default-character-set=utf8 your_database_name

import mysql.connector

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

cnx = mysql.connector.connect(**config)

mysqldump -u your_username -p --default-character-set=utf8 your_database_name > backup.sql

mysql -u your_username -p --default-character-set=utf8 your_database_name < backup.sql