MySQL 8.0角色与授权

1、用户

已经存在了employees、employees_read用户，新建一个写用户

mysql>  CREATE USER 'employees_write'@'%' IDENTIFIED BY '123' ;
Query OK, 0 rows affected (0.00 sec)

2、新建角色

mysql> create role 'employees_r','employees_rw','employees_admin';

（1）admin角色授权

mysql> grant all on employees.* to employees_admin;
Query OK, 0 rows affected (0.01 sec)

（2）只读角色授权

mysql> grant select on employees.* to employees_r;
Query OK, 0 rows affected (0.00 sec)

（3）读写角色授权

mysql> grant select,insert,update,delete on employees.* to employees_rw;
Query OK, 0 rows affected (0.00 sec)

3、用于赋予角色

mysql> grant employees_admin to employees@'%';
Query OK, 0 rows aff