mysql添加用户

grant usage on *.* to 'user'@'hostname' identified by 'passwd' with grant option;  //添加用户

grant all privileges on *.* to 'user'@'hostname' identified by 'passwd';  //添加权限

flush privileges; //更新权限