添加用户：
insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values ("192.168.186.1","allen",password("allen"),‘‘,‘‘,‘‘);
刷新：
flush privileges;
授权：
grant select on test.* to ‘allen‘@‘192.168.186.1‘;
刷新：
flush privileges;
查看授权情况
SHOW GRANTS FOR allen@192.168.186.1;
删除用户：
DROP USER allen@192.168.186.1;