Linux下MySQL导入sql文件乱码

一、先进入Mysql
二、输入以下三条命令
CREATE DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON database_name.* TO username@localhost IDENTIFIED BY ‘password’;
FLUSH PRIVILEGES;
三、进入数据库 use database_name;
set names utf8; (或其他需要的编码)
source example.sql; (sql文件存放路径)