库级别
grant all on nnshop.* to lisi@'192.168.1.%'
revoke all on nnshop.* from lisi@'192.168.1.%'
表级别
grant insert,update,select on nnshop.goods to lisi@'192.168.1.%'
库级别
grant all on nnshop.* to lisi@'192.168.1.%'
revoke all on nnshop.* from lisi@'192.168.1.%'
表级别
grant insert,update,select on nnshop.goods to lisi@'192.168.1.%'