mysql-给用户添加表权限

指定用户的表权限

grant select ,insert,update,delete,index on mqdt_sjzl_dev.t_bz_jdsf_question_reform to shujugu@'%';

给mysql用户分配制度库的查询权限

GRANT select ON mqdt_sjzl_longtu_dev.* TO shujugu@'%';

grant select ,insert,update,delete,index on mqdt_sjzl_dev.t_yw_lfsd_zfrw to shujugu@'%';

grant select ,insert,update,delete,index on mqdt_sjzl_dev.t_yw_lfsd_yh to shujugu@'%';

grant select ,insert,update,delete,index on mqdt_sjzl_dev.t_yw_lfsd_wgy to shujugu@'%';

grant select ,insert,update,delete,index on mqdt_sjzl_dev.t_yw_lfsd_sdry to shujugu@'%';