linux解决数据库乱码问题吗

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

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

-- 查看字段字符集
SHOW FULL COLUMNS FROM 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;

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

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

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

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase",
  charset='utf8mb4'
)

String url = "jdbc:mysql://localhost:3306/yourdatabase?useUnicode=yes&characterEncoding=UTF-8";
Connection conn = DriverManager.getConnection(url, "yourusername", "yourpassword");