mysql在suse系统乱码

SHOW VARIABLES LIKE 'character_set_%';

character_set_server = utf8
collation_server = utf8_general_ci

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

sudo systemctl restart mysql

SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'your_database_name';

ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci;

SHOW CREATE TABLE your_table_name;

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

SHOW FULL COLUMNS FROM your_table_name;

ALTER TABLE your_table_name MODIFY your_column_name your_column_type CHARACTER SET utf8 COLLATE utf8_general_ci;

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

import mysql.connector

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

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