项目有个需求:把表分权限,分割给各个企业.
当时就用Navicat去手动添加客户,再划分权限,结果不知道为什么登陆不上,还待研究..........
后来宋同事用命令行实现了,操作如下:
创建用户:用户名test1, by后面的是密码
create user 'test1'@'%' identified by 'test1';
授权:把对表nb_AccList 的select权限分给test1
grant select on sync_users.nb_AccList to test1@'%' identified by 'test1';
查看用户的权限:
mysql> show grants for test1;
+------------------------------------------------------------------------------------------------------+
| Grants for test1@% |
+------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'test1'@'%' IDENTIFIED BY PASSWORD '*06C0BF5B64ECE2F648B5F048A71903906BA08E5C' |
| GRANT SELECT ON `sync_users`.`nb_AccList` TO 'test1'@'%' |
+------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)