mysql不显示中文

-- 查看数据库的字符集
SHOW CREATE DATABASE your_database_name;

-- 修改数据库的字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 查看表的字符集
SHOW CREATE TABLE your_table_name;

-- 修改表的字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 查看列的字符集
SHOW FULL COLUMNS FROM your_table_name;

-- 修改列的字符集
ALTER TABLE your_table_name MODIFY your_column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

jdbc:mysql://localhost:3306/your_database_name?useUnicode=yes&characterEncoding=UTF-8

import mysql.connector

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

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

query = "SELECT * FROM your_table_name"
cursor.execute(query)

for row in cursor:
    print(row)

cursor.close()
cnx.close()