创建数据账号只有个别表的权限_限制账号只能访问指定表、视图、字段

创建新用户并授权管理数据库中的表 CREATE USER ``@`%`IDENTIFIED BY '';

GRANT PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ''@'%';

GRANT ALL PRIVILEGES ON ``.`` TO ''@'%';

GRANT SELECT ON `mysql`.`help_topic` TO ''@'%';

GRANT SELECT ON `mysql`.`func` TO ''@'%';

GRANT SELECT ON `mysql`.`time_zone` TO ''@'%';

GRANT SELECT ON `mysql`.`slow_log` TO ''@'%';

GRANT SELECT ON `mysql`.`time_zone_transition` TO ''@'%';

GRANT SELECT ON `mysql`.`event` TO ''@'%';

GRANT SELECT ON `mysql`.`proc` TO ''@'%';

GRANT SELECT ON `mysql`.`help_category` TO ''@'%';

GRANT SELECT ON `mysql`.`help_relation` TO ''@'%';

GRANT SELECT ON `mysql`.`help_keyword` TO ''@'%';

GRANT SELECT ON `mysql`.`general_log` TO ''@'%';

GRANT SELECT ON `mysql`.`time_zone_leap_second` TO ''@'%';

GRANT SELECT ON `mysql`.`time_zone_transition_type` TO ''@'%';

GRANT SELECT ON `mysql`.`time_zone_name` TO ''@'%';

示例

创建新用户test01并授权管理数据库rds001中的表test100。CREATE USER `test01`@`%`IDENTIFIED BY 'passwd';

GRANT PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'test01'@'%';

GRANT ALL PRIVILEGES ON `rds001`.`test100` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`help_topic` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`func` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`time_zone` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`slow_log` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`time_zone_transition` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`event` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`proc` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`help_category` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`help_relation` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`help_keyword` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`general_log` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`time_zone_leap_second` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`time_zone_transition_type` TO 'test01'@'%';

GRANT SELECT ON `mysql`.`time_zone_name` TO 'test01'@'%';

说明 如果将命令第三行的test100更改为*，就和通过控制台创建的账号一样了，也可以在控制台看见此账号的所属数据库。