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;

mysqldump -u your_username -p your_database_name --default-character-set=utf8mb4 > your_output_file.sql

file -i your_output_file.sql

mysqldump -u your_username -p your_database_name --default-character-set=utf8mb4 users > users.sql