mysql 建库，授权操作

mysql 建GBK 区分大小写的数据库库

create database database_name DEFAULT CHARACTER SET gbk COLLATE gbk_bin; 

建用户

CREATE USER 'thesis'@'127.0.0.1' IDENTIFIED BY 'thesis-123'; 

授权

GRANT ALL ON *.* TO 'thesis'@'127.0.0.1';

刷新

flush privileges;

csv导出select查询内容

    select paper_id,title from t_paper where bank_id=2 into outfile '/tmp/paper_bank_2233.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';