MySQL 5.7的角色功能:
创建用户并授予用户角色功能:
mysql> create user 'junior'@'127.0.0.1' identified by '123';
Query OK, 0 rows affected (0.01 sec)
mysql> create user 'tom'@'127.0.0.1' identified by '123';
Query OK, 0 rows affected (0.00 sec)
mysql> create user 'jim'@'127.0.0.1' identified by '123';
Query OK, 0 rows affected (0.01 sec)
mysql> grant proxy on 'junior'@'127.0.0.1' to 'tom'@'127.0.0.1';
Query OK, 0 rows affected (0.01 sec)
mysql> grant proxy on 'junior'@'127.0.0.1' to 'jim'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)
mysql> grant select on *.* to