mysql 乱码

1. sudo  vi /etc/mysql/my.conf

client和mysqld后面分别设置如下

[client]
default-character-set=utf8

[mysqld]
character_set_server=utf8

2. 重启mysql服务

sudo services mysql restart

3. mysql命令行设置

set names utf8

4. 查看当前字符集

show variables like 'character\_set\_%'; 

5.修改数据库和表的字符集

ALTER DATABASE `db_name` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

ALTER TABLE `tb_name` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

6. 创建数据库和表

create database mydb;
use mydb;

CREATE USER 'mydb'@'%' IDENTIFIED BY 'mydb';
GRANT ALL ON mydb.* TO 'mydb'@'%';

create table mytable (
 id bigint not null,
name varchar(510),
primary key(ad_id)
) default charset=utf8;

7. 导入数据：

LOAD DATA LOCAL INFILE 'C:\\gbk.txt' INTO TABLE yjdb;

注意：UTF8不要导入gbk，gbk不要导入UTF8;