为了约束数据消费者的数据使用范围,MySQL限制用户登录次数和同时连接数量。
create user user1@'%' identified by 'user1';
grant select on redbit.emailList to user1@'%';
grant select on redbit.varlist to user1@'%';
grant select on lotus.hfxweathernow to user1@'%';
grant select on lotus.hfxlocation to user1@'%';
alter user user1@'%' with MAX_USER_CONNECTIONS 2 MAX_CONNECTIONS_PER_HOUR 4;
参考文档: