mysql查询数据库中文乱码

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

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

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

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

import pymysql

conn = pymysql.connect(
    host='your_host',
    user='your_user',
    password='your_password',
    database='your_database',
    charset='utf8mb4'
)

import sys
sys.stdout.reconfigure(encoding='utf-8')

import pymysql

# 连接数据库
conn = pymysql.connect(
    host='your_host',
    user='your_user',
    password='your_password',
    database='your_database',
    charset='utf8mb4'
)

try:
    with conn.cursor() as cursor:
        # 查询数据
        sql = "SELECT * FROM your_table_name WHERE id = %s"
        cursor.execute(sql, (1,))
        result = cursor.fetchone()
        print(result)
finally:
    conn.close()