mysql创建用户授权

create user 'admin'@'localhost' IDENTIFIED BY '密码';
grant all privileges on *.* to 'admin'@'localhost' with grant option; //本机
grant all privileges on *.* to 'admin'@'%' with grant option;//所有IP
grant all privileges on *.* to 'admin'@'192.168.1.%' with grant option;//IP段
flush privileges;