Mysql创建用户并为用户分配数据库中多表不是全部表权限:
只能一个一个表来分配了,没有整合单个命令的.
知道的请指教,呵呵
GRANT SELECT,INSERT,UPDATE
ON 数据库.表1TO 'agents'@'localhost'
IDENTIFIED BY '密码';
GRANT SELECT,INSERT,UPDATE
ON 数据库.表2
TO 'agents'@'localhost'
IDENTIFIED BY '密码';
GRANT SELECT,INSERT,UPDATE
ON 数据库.表3
TO 'agents'@'localhost'
IDENTIFIED BY '密码';
GRANT SELECT,INSERT,UPDATE
ON 数据库.表4
TO 'agents'@'localhost'
IDENTIFIED BY '密码';
GRANT SELECT,INSERT,UPDATE
ON 数据库.表5
TO 'agents'@'localhost'
IDENTIFIED BY '密码';
GRANT SELECT,INSERT,UPDATE
ON 数据库.表6
TO 'agents'@'localhost'
IDENTIFIED BY '密码';
.................