设置mysql记录SQL语句日志文件

set global general_log_file="/tmp/general.log";
开启set global general_log=on;关闭set global general_log=off;
创建用户
create user 'zhang'@'%' identified by '密码';
赋予权限
grant all privileges on *.* to 'zhang'@'%' identified by '密码' with grant option;

 all  privileges 
 可以替换为 select, update,... create之类的
刷新权限
flush privileges;