创建新用户
grant all privileges on *.* to '用户名'@'可登录主机' identified by '密码' with grant option;
例
grant all privileges on *.* to 'test'@'%' identified by 'root' with grant option;
赋予新用户权限：
grant select,insert,update,delete on *.* to '用户名'@'可登录主机' identified by "密码";
例：
grant select,insert,update,delete on *.* to 'test'@'%' identified by "root";
刷新权限表
flush privileges;