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