grant all privileges on 库名.表名 to ‘用户名‘@‘IP地址‘ identified by ‘密码‘ with grant option; flush privileges;
mysql新建用户与授权
原文:https://www.cnblogs.com/liyuchuan/p/11424996.html