MySQL授权

1.创建新用户

create user 'employee'@'localhost' identified by 'employee123';

2.授权读权限

grant select on employee.department to 'employee'@'localhost';

3.授权读（两个字段）权限

grant select（firt_name,last_name） on employee.employees to 'employee'@'localhost';

4.登录mysql

mysql -uroot -proot123

5.查departments表

use employees;

select * from departments limit 5;

6.查employees表所有字段（报错）

select * from employees limit 5;

7.查employees表两个字段

select first_name,last_name from employees limit 5;

8.执行以下查询，报错

select departments.dept_name,employees.first_name,

employees.last_name

from departments natural join dept_emp natural join employees limit 5;

9.查关联的表

select user();

desc departments;

desc dept_emp;

10.授权

grant select(deprt_no,emp_no) on employees.dept_emp to employee@localhost;

grant select (emp_no) on employees.employees to employee@localhost;

11.查看权限

show grants for 'employee'@'localhost'\G;

12.再次查询，不会报错

13.update数据报错

update employees set first_name='Georgiio' where emp_no=10001;

14.delete数据报错

delete from employees where emp_no=10001;

15.退出

exit