创建所有权限

GRANT ALL PRIVILEGES ON *.* TO 'query'@'%' IDENTIFIED BY 'arswerse4165465';

创建只能有 select,update,delete,insert

GRANT select,update,delete,insert on *.* to 'query223'@'%' identified by 'arswerse4165465';

创建只能有 select,update,delete,insert（91_weixin）

query23-用户名

arswerse4165465-密码

91_weixin-数据库名称

grant select,update,delete,insert on 91_weixin.* to 'query23'@'%' identified by 'arswerse4165465';

最后，刷新生效

flush privileges;