linux mysql 开启menelog

 把日志文件放在指定目录下

set global general_log_file="/tmp/general.log";

 

 

新建用户：create user 'imooc'@'%'

 

赋予新用户所有权限

grant all privileges in *（数据库）.*（表） to 'imooc'@'%' identified by '123456' with grant option;

 

回收权限

revoke all privileges on *.* from imooc;

flush privileges;刷新权限

 

忘记密码